Hisham
Use the query or view designer to visually create your query, then go to the "View SQL" option in the View menu, and there you'll see the way you should write your select statement. When visually designing the query, it specifically asks you what kind of join to do.

HTH
Jaime


>Dear All,
>
>I have a small problem which will be a big solution for me, where I have a SQL statement not giving the right answer for what I need, I have table (a) and table (B) I need to show all records which in table (a) and the releated records in table (b) but the problem is giving me the opposite result it is giving table (b) what only releated in table (A) so I do not get the right answer, I wanted to have all the records in (a) and matching with records in (b) table, any idea ????
>
>thanks
>
>Hisham