>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).