in an access database, I have 2 tables (table1 and table2), and 2 specific fields I&#039m trying to compare, the sql looks something like this:<BR><BR>Select table1.field1, table2.field1, table1.field2<BR>FROM table1 LEFT JOIN table2 ON table1.field1 = table2.field2<BR><BR>in access it works, when I converted to sybase it doesn&#039t work, the error I get is:<BR><BR>Incorrect Syntax Near &#039JOIN&#039<BR><BR><BR>If anyone had any ideas as to what I might try, I&#039m all ears. Thanks in advance.<BR><BR>Nathan Pond