How can I pull second field from the sql nesting query

[Stalk]

Select nid, date_p, accession from table1

    where accession in(select distinct accession from table2).

I also want to pull pid field along with accession field from table2.

What is the best way?

Thank you

[PeterClemmensen · Accepted solution]

Something like 

select a.nid
      ,a.date_p
	  ,a.accession as a_accession
	  ,b.pid 
	  ,b.accession as b_accession
from table1 as a, table2 as b_accession
where a.accession = b.accession

[Stalk]

Thank you. It worked