Still at it
Tuesday, 11. April 2006, 13:50:33
This project has turned out to be a nightmare.
There are 3 tables in the DB. One for customers, one for locations and one for contacts. The locations table is a child of customers and contacts table is a child of locations.
I have to build a query that allows for searching any and all records based on five criteria; equal to, not equal to, greater than, less than, or between range X and Y.
This may seem like an easy task, but there are 70 fields in the customer table and since there are two child tables as well - the join query is a son of a bitch.
There are 3 tables in the DB. One for customers, one for locations and one for contacts. The locations table is a child of customers and contacts table is a child of locations.
I have to build a query that allows for searching any and all records based on five criteria; equal to, not equal to, greater than, less than, or between range X and Y.
This may seem like an easy task, but there are 70 fields in the customer table and since there are two child tables as well - the join query is a son of a bitch.
WIDGETIZE