>>>What is wrong with my second (SQL Server) expression?
>>
>>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 (....)
>
>Thank you for your input.
Do you mean you don't trust me? <g>
If it's not broken, fix it until it is.
My Blog