>>>>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>
I trust your technical knowledge.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham