Getting mutliple values from mutliple tables

[ahmee]

There are two table from which i want to get value
1. heads
2.subheads


The field name in heads table is:

id, head_name.


the field name in subheads table is:
id,subhead_name.



i want to get value from these two table when the value mean id is '1'

i wrote the query something like this

SELECT `head_name`,`subhead_name` FROM `heads`,`subheads` WHERE `head_name.id` = '1' AND `subhead_name` = '1

'

[Rabbit]

So there's no question then?

[adriancs]

SELECT `head_name`,`subhead_name` FROM `heads`,`subheads` WHERE `heads`.`id` = 1 and `subheads`.`id` = 1;
SELECT `head_name`,`subhead_name` FROM `heads`,`subheads` WHERE `heads`.`id` = `subheads`.`id` and `heads`.`id` = 1;