>>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 ; >> FROM ; >> Table1 ; >> INNER JOIN Table2 ; >> ON Table1.Field1 = Table2.Field2 ; >> 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).