Posted by MVM on 12/05/93 11:29

Hello everyone,
I need some help building a query using three tables and I am having
difficulty writing the query.
Here are the tables:

GENERAL:
GID - primary key
PARCEL
EDITDATE
MAPCODE


SALES:
GID - foreign key
SLSDATE
SLSAMOUNT


RESIDENCE:
GID - foreign key
OCCUPANCY
LIVINGAREA


The relationship is one-to-many from the General table to both the Sales and
the Residence tables. I want to allow users to query by every field in each
of these tables. The problem is that this is a Sales search, so there must
be a record in the Sales table before it searches all other criteria. How
do I setup the joins for this?
Thanks!
MVM

[Back to original message]