gentforreal
Programmer
I have three tables Zenter which contains only 2 zipcodes, Zmake which contains only 3 makes of autos and Automaster with contains 1,900,000 records which includes a persons zip and the make they own.
Shouldn't the following display all the zips and makes associated with the first two tables them from the automaster? What I want to get are the hundreds of records I know are in the automaster.
All I have returned is the first zip in zenter and the first make in zmake.
select * from automaster;
where zmake.make = automaster.make;
and zenter.czip = automaster.zip
Shouldn't the following display all the zips and makes associated with the first two tables them from the automaster? What I want to get are the hundreds of records I know are in the automaster.
All I have returned is the first zip in zenter and the first make in zmake.
select * from automaster;
where zmake.make = automaster.make;
and zenter.czip = automaster.zip