Left Join Problem

#1

We would like to restrict the number of records returned
in a LEFT JOIN query but we find that it doesn't work as
it supposed to be.

Query:

select t1.statdescr
from table1 as t1 with (nolock)
left join table2 as t2
on t1.tpklrpap = t2.tfklrpap
and t1.statdescr not like 'CANCEL%'

However, we find that it still pulls those records with
CANCEL

Thanks

#2

Hi

select t1.statdescr
from table1 as t1 with (nolock)
left join table2 as t2
on t1.tpklrpap = t2.tfklrpap
WHERE t1.statdescr not like 'CANCEL%'

Regards
Mike

"Daniel" wrote:

Quote:

We would like to restrict the number of records returned
in a LEFT JOIN query but we find that it doesn't work as
it supposed to be.

Query:

select t1.statdescr
from table1 as t1 with (nolock)
left join table2 as t2
on t1.tpklrpap = t2.tfklrpap
and t1.statdescr not like 'CANCEL%'

However, we find that it still pulls those records with
CANCEL

Thanks

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Left Join Problem

microsoft.public.sqlserver.clustering microsoft.public.sqlserver.clustering

Left Join Problem - 03-22-2005 , 09:08 PM

RE: Left Join Problem - 03-23-2005 , 05:11 AM