Posted by boa on 10/02/22 11:55

* eurolinux@hotmail.com wrote, On 14.08.2006 19:42:
> 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))
> __________________________________________
>

select t1.f1, t2.f1
from t1, t2
where t1.f1 between t2.f1 - 1 and t2.f1 + 1

Is that what you meant? :-)

HTH
Bjørn

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

[Reply to this message]