I'm using sqlite. I have 2 tables. One is a detail table. I want to select all the records in table 1 only if they have details in table 2 where the column "type" equals "List"
select * from Vehicles
select count > 0 from list_detail where type = "List"
Any help would be greatly appreciated.