sanjeev_krs2004 (8/8/2008)
Hican we do add OR or AND in INNER and OUTER joins conditions..?
if anybody has any clue, please reply.
Yes, you can. The following (absolutely useless in terms of the result) query shows it:
select c.name
from sys.objects as o
join sys.columns as c on o.object_id = c.object_id
OR ( (o.object_id = c.object_id
AND o.object_id = 4) )
Regards,
Andras