>>>I don't think you can make it work this way. Simply use two separate JOINS with a UNION, e.g. JOIN with the table based on the field and condition and then UNION with join based on another field with WHERE.
>>>
>>>Alternatively you can do
>>>
>>>JOIN TABLE1 ON (Table2.Order_NO > 0 and Table2.ID_Field = ..) OR (....)
>>
>>
>>You can :-)))))
>>Just check my answer :-))))))
>
>Yes, I did. Funny I thought exactly as Sergey here.
>
>Looks like you can, but I would still go with my suggestion instead - for clarity.
My suggestion is optimizable :-))))))))))))
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.