Posted by eurolinux on 10/02/43 11:55

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

• Next in forum: Re: need help with LEFT JOIN statemen
• Prev in forum: Re: Create View in SQL Server with data types
• Thread view: need help with LEFT JOIN statemen

[Reply to this message]