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