I NEED SQL help!

Is there a way to syntatically join these two ideas??

var1=select conference_id from table1 where conference_name=’Trauma’;

var2=select conference_date from table2 where conference_id.table2=var1;

Answer: select conference_date from table2,table1 where conference_id.table1=conference_id.table2 and conference_name.table1=’trauma’;

I want to find the corresponding primary key to the first table using “conference name” and then look up the conference date using that primary key from the first table.

Thanks for trying Wen! No thanks to all u other a-holes. The answer was so simple i overlooked it!