>Hilmar,
>
>Thank you for everything. You have really helped me with the explanations and examples on Sql JOIN
>
>God Bless
>
>Fred

To add to Hilmar's reply check Re: Speed query with rushmore index Thread #1202405 Message #1202569 If you need to restrict records from the table on the right side of the left join, e.g.

select records from tableA left Join tableB where TableB some condition you would need to move Some Condition into JOIN clause, otherwise you only get records from tableA which correspond to the records in TableB satisfying the condition.