C
cooper
I am having a problem joining my tables in a query. I am trying to use a
small list of just names, and using also another bigger list of addresses and
the names that correspond. I want a query with the small list of names and
the addresses of those people.
I tried this...i am used to access 2003..but at my office we have
2000...soo...
select firstname, lastname, apartment, streetnumber, apartment2, streetname,
city_state, zipcode, firstname, lastname
from allvoterspittsburgh, giver, allvotersnotpitts
where allvoterspittsburgh.firstname=allvotersnotpitts.firstname and
allvoterspittsburgh.lastname=allvotersnotpitts.lastname
i dont understand how i need to join these....it keeps on saying that i have
syntax errors missing operator...is 2000 different?
small list of just names, and using also another bigger list of addresses and
the names that correspond. I want a query with the small list of names and
the addresses of those people.
I tried this...i am used to access 2003..but at my office we have
2000...soo...
select firstname, lastname, apartment, streetnumber, apartment2, streetname,
city_state, zipcode, firstname, lastname
from allvoterspittsburgh, giver, allvotersnotpitts
where allvoterspittsburgh.firstname=allvotersnotpitts.firstname and
allvoterspittsburgh.lastname=allvotersnotpitts.lastname
i dont understand how i need to join these....it keeps on saying that i have
syntax errors missing operator...is 2000 different?