General information
Category:
Coding, syntax & commands
as you discovers (and as others told you) the View Designer
is very limited (to say the least)
because the way the view designer builds its SQLs you may have better
results if you start with one of the chield tables link to the parent and
then link to the second chield
you will never have it re-opening in the View desinger though if you need to join a table with more than 2 tables
Arnon
>Howdy,
>
>I'm simply trying to create a View through the View designer which connects my main table to 2 other tables by way of outer joins.
>
>When I do it in the view designer, and save it - it will run correctly, but when I try to modidy the view - ir crashes.
>It seems that the view designer creates the SQL syntax incorrectly.
>
>1. This is what the View Designer gives me as the SQL syntax
>
>SELECT MAIN.ID, NAMES.FNAME, STATES.STATE ;
> FROM MAIN LEFT OUTER JOIN NAMES;
> LEFT OUTER JOIN STATES ;
> ON MAIN.name = STATES.name ;
> ON MAIN.id = NAMES.id
>
>2. Running it is O.K.
>
>3. When I save the view and try to modify it I get the Fox error:
>SQL: Column 'NAME' is not found.
>
>John F.
>Needs View help in NYC
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only