Information générale
Catégorie:
Codage, syntaxe et commandes
When I run the View Designer I get the following message when I try to quit the designed:
SQL Column "Auth_code" is not found. There is an auth_code field in each of the tables that makes reference to them. I picked them with the designer. Here is the SQL code when viewed:
SELECT *;
FROM calllink!faxque INNER JOIN calllink!schedule;
INNER JOIN calllink!pending;
INNER JOIN calllink!assigned;
INNER JOIN calllink!account ;
ON Assigned.actnum = Account.actnum ;
ON Pending.actnum = Assigned.toll ;
ON Faxque.audit_num = Pending.audit_num ;
ON Faxque.audit_num = Schedule.audit_num
What is going on?
Ed
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement