SQL Assist?

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 […]