Information générale
Catégorie:
Codage, syntaxe et commandes
Titre:
Syntax error using view designer
I'm trying to use the view designer to create a view, but I get an error with the SQL that it generates (and therefore I can't saveit).
The SQL is:
SELECT Orders.*;
FROM asn!orders INNER JOIN asn!consign;
LEFT OUTER JOIN asn!consign Consign_a ;
ON Orders.ship_for = Consign_a.consign_id ;
ON Orders.consign_id = Consign.consign_id
The error is
SQL: Column 'SHIP_FOR' is not found
BUT, if I run the SQL from the command window, it will fail the first time and succeed the 2nd. I found that if the Orders table is already open, then it will work.
What's the deal?
Bob
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