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