>>Syntax 1.: >> SELECT ; >> Table1.Field2,; >> Table2.Field3 ; >> FROM ; >> Table1,; >> Table2 ; >> WHERE ; >> Table1.Field1 = Table2.Field2 ; >> INTO CURSOR SQLType1 >> >>Syntax 2. >> SELECT ; >> Table1.Field2,; >> Table2.Field3 ; >> <b>Table3.Field2 ;</b> >> FROM ; >> Table1 ; >> INNER JOIN Table2 ; >> ON Table1.Field1 = Table2.Field2 ; >> <b>JOIN Table3 ; >> ON table1.field3 = table3.field1 ;</b> >> INTO CURSOR SQLType1 >> >>>>Type 1 allows the user to combine many more tables then Type2, but Type 2 allows the user to easily join tables in various ways (LEFT JOIN, RIGHT JOIN, FULL JOIN etc).