In foxpro and SQL server, we want to Join more than 2 tables in SQL select.
But I cann't find the document talking about this. I want to know the nested jion as well.

1. Where can we find the doc, article or book talking about those?

2. Is this the nested join? How can it work?

FROM tab1 LEFT OUTER JOIN tab1.c3 = tab2.c3
RIGHT OUTER JOIN tab3 LEFT OUTER JOIN tab4
ON tab3.c1
ON tab2.c3 = tab4.c3

I got this example from SQL 7.0 Books on line (SQLBOL.chm). The title is "FROM (T-SQL)".


Thanks in advance



Jim