Re: Join or subquery

[Peter Brawley]

Will you actually use all info from each row of both tables? If not, change * to the list of columns needed.

A join would be simple, something like ...

select ...
from table1
join table2 on table2.bscra_id = table1.id
order by table1.end_date desc;