Join issue

Hi all,

Request your help on this:

We have two tables table 1 and table 2 .Table 1 has 1 to many relationship with table 2 .We need all the records from table 1 .While doing  join between these 2 tables, table2(table in many side) is becoming the left table  and table 1(table in 1 side) is becoming the right table.So can not get all the entries from table 1.I have tried doing this in edit query but there also no luck .

Please can you suggest.

Thanks,

saranee