General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>Either chenge the order of "ON..." clauses so :
>ON ONHND.PARTNO=MASTER.PARTNO;
>ON MASTER.GROUP=GROUP.GABBR;
>
>Or :
>FROM GROUP RIGHT OUTER JOIN MASTER ;
>ON MASTER.GROUP=GROUP.GABBR;
>INNER JOIN ONHND;
>ON ONHND.PARTNO=MASTER.PARTNO;
>
>Otherwise you'd get that "forever" join. Take a look at how 4 tables in testdata.dbc (home()+"samples\data") are connected in a view.
>Cetin
THANKS!! Microsoft's documentation of SELECT - SQL is soooo sparce on examples I wasn't sure what was legal syntax and what wasn't:) Thanks for your help
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