|
|
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
Navigation:
[Reply to this message]
|