[AccessD] What type of query....

Bobby Heid bheid at sc.rr.com
Thu Feb 8 22:26:16 CST 2007


Hey,

I have this scenario

Table 1:
PID
FName
Lname

Table2:
ZID
PID
TypeID
Zip

Table3:
TypeID
Type

Note that there are only 2 types, home and work.

What I want is to have:
Fname       Lname               HomeZip    WorkZip
Joe            Schmoe	      29977        78665
Suzy         Chapstick           98847

To do this in one query, what kind of query would I use?  Basically, I have
a one-to-many relationship and I want to have both zips for each name
record.

Thanks,
Bobby





More information about the AccessD mailing list