>It was strange to me too that it works. Because I have never before used this syntax. I thought that JOIN can only use something like
>ON TABLE1.FIELD = TABLE2.FIELD.
>
>I hope I am not doing something that I will later regret when using syntax:
>
>

>Select * from MYTABLE1 join MYTABLE2 on MYTABLE1.FLD1 = MYTABLE2.FLD2 and MYTABLE2.SOMEDATE between (BEGINDATE and ENDDATE)
>

>
>I hope someone who knows more about correct SQL Select will warn me of the potential problem.

Actually, this is exactly the right solution. This is a question I cover when I do sessions on queries. The general rule of thumb is that if the condition affects which records come into the query via the outer join, it belongs in the JOIN clause. If the condition is intended to filter out records _after_ the outer join (for example, if you only wanted parts of a certain type), put it in the Where clause.

Tamar