Databases Querying Relational Databases Subqueries Subqueries

Can I get help with Question 4: Derived Tables?

I have a solution that should work as far as I can tell, but isn't accepted.

SELECT s.* FROM Sale AS s LEFT INNER JOIN ( SELECT Gender FROM Customer ) AS c ON s.CustomerID = c.CustomerID WHERE c.Gender = 'F';

Please point out what I'm doing wrong.

1 Answer

You do not need the first 'AS' to alias the Sale table. You only need to use AS to name a derived table. Your derived table will need to contain the field you plan to use to JOIN it to another table (CustomerID). Also they want you to select only females into your derived table.