[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

Where Statement Placement Question

Should the results be the same with
        Where rd.REQUISITION_ITEM_ID = ro.REQUISITION_ITEM_ID
as with
        Where ro.REQUISITION_ITEM_ID = rd.REQUISITION_ITEM_ID
or is placement important.

Also what about
        Where ro.ORDER_ITEM_ID (+) = oi.ORDER_ITEM_ID
vs.
        Where oi.ORDER_ITEM_ID = ro.ORDER_ITEM_ID (+)

I have not been able to find anything on this.
Thanks in advance

Dave Benzenhafer