Jason Finley13,168 Points
I have no idea why this isn't returning the right amount of rows. Please tell me what I've got wrong here.
I don't know what I'm missing since I cannot see the results.
Gabriel Pierce-Lackey11,005 Points
You just need to removed the s.
SELECT * FROM sale s INNER JOIN (select customerid FROM customer WHERE gender = 'F') c on s.customerid = c.customerid