• sanjeev_krs2004 (8/8/2008)


    Hi

    can 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


    Andras Belokosztolszki, MCPD, PhD
    GoldenGate Software