YA AbidakadrPro Student 2,017 Points
help without using the keyword in
select * from sale where customerid in ( select customerid from customer where gender like "f");
i should not use in. how?
ivana kantnerova12,986 Points
maybe, try this .. in the select there cannot be the same names of attributes ... i suppose you have to use the name of table too and ... gender like 'f' not "f"
select * from sale where sale.customerid in ( select customer.customerid from customer where gender like "f");