I have the following requirements for three queries I have to build, but the ones I've written bring back "too much data." The requirements are as follows:
Query 1 - Hispanic Customers
Customer ID
First Name
Last Name
Car Color
Query 2 - Customers who were born in March and own a pink Pontiac.
Customer ID
Last Name, First Name [Customer Name]
Query 3 - White Customers who own a Toshiba Laptop or an HP Laptop and a blue Buick. Customer ID
Last Name, First Name [Customer Name]
Computer
This is what I've written, which brings back to too data:
1)
SELECT DISTINCT CustomerID, firstname, lastname, Description
FROM customers, zlu_Race
WHERE zlu_race.description="Hispanic" Or zlu_race.RaceID=3;
2)
SELECT customerid, (FirstName+'_'+LastName) AS [Customer Name], zlu_birthmonth.description
FROM Customers, zlu_BirthMonth
WHERE zlu_birthmonth.description="March";
3) Have no idea how to write it.
What am I doing wrong?
Can some help get these queries to bring back the correct records? I keep writing over and over, and it's driving me up the wall. Thanks a zillion!
Additionally:
NOTE: The main table = Customers, and it is normalized.
For lookup (zlu_) tables, I have:
zlu_BirthMonth
zlu_CarColor
zlu_Cars
zlu_Computers
zlu_Race
zlu_Residence
All zlu_ tables have an ID, Code, Description, ListOrder, and Active field.