problem displaying mysql query for unmatched rows

[imi_99]

<p>SELECT DISTINCT id, heading_title, opening_day, opening_time, opening_id FROM heading_openinghour CROSS JOIN timetble WHERE heading_openinghour.id=timetble.heading_id order by heading_openinghour.id, timetble.opening_id;</p>

when run in mysql it shows this result , u can see here,
http://www.whatahome.co.uk/test.html

Hello I am using this query to generate the result. This is ok but I come across other issue, which if rows in first table do not match to 2nd table then it do not show those rows
do someone know that if I can get same result but also those rows which are only in table1 and have no relation with table 2
thanks for help??

[subwayman]

Change your join. A right join is always useful when handling unmatched columns.

[imi_99]

subwayman wrote:

Change your join. A right join is always useful when handling unmatched columns.

yep u probably right. Left join works in my case, if i use right join then it misses rows in table1. But i need all tables in table1. So if i use left join then that works
thanks