need help with LEFT JOIN statemen

Giganews Newsgroups
Subject: need help with LEFT JOIN statemen
Posted by:  eurolin…@hotmail.com
Date: 14 Aug 2006

I'm trying to left join a table where there are two identical fields

I want to select all records in a field from the left table and only
those records from the identical field of the right table which are not
bigger or smaller then 1

both field in the tables are integer data type

Can someone help

I tried this code but it does not work, I'm not sure if I can use these
operators <>
__________________________________________
SELECT Table1.field1,Table2.field1
FROM Table1 RIGHT JOIN Table2 ON (Table1.field1 = Table2.field2) AND
not (Table1.field1 > (Table2.field2+1)) AND not (Table1.field1 <
(Table2.field2-1))
__________________________________________

Replies