I have the following statement:
select region_id from regions
where region_name = 'Europe'
I need the Output from this in the following statement where 'bla' is:
select count(*) from countries
where region_id = 'bla'
How can I do that?
Try the IN clause
select distinct * from countries
where region_id IN (select region_id from regions
where region_name = 'Europe')
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With