>Good Morning
>
>I am in need of setting relations between several (3 or 4) SQL tables to perform an accurate query. Is this done with the JOIN command? Any help that you could give or pass to me would be greatly appreciated. Thank you
Yes. Inner, Left, Right and Full join. Check testdata.dbc for an example joining 4 tables. But unlike the example there try to use syntax like :
... from tab1 ;
join tab2 ;
on tab1.field = tab2.field ;
join tab3 ;
on tab3.field = tab2.field2 ;
...
This way it's easier to set them correctly.
Cetin