Re: Query - multiple joins won't return any records
No, sorry. I did remove the parens but as expected, no effect.
There are no FKs that the database is aware of.
Putting the vals in the Where clause won't work.
Did you look at my sql statement?
How would I do that and get the records from the different tables?
Did you read my replies to Peter Brawley? That might help.
As far as the PK goes, my convention is PK is RecordID and FKs are table related, ie DivisionID, TeamID, ObjectID, etc.
They're irrelavent to my problem.
Subject
Written By
Posted
February 13, 2015 09:32PM
February 14, 2015 10:21AM
February 14, 2015 10:57AM
February 14, 2015 03:03PM
February 15, 2015 01:40AM
February 15, 2015 09:59AM
February 15, 2015 01:40PM
February 15, 2015 02:33PM
February 15, 2015 02:54PM
Re: Query - multiple joins won't return any records
February 15, 2015 03:09PM
February 15, 2015 07:59PM
February 19, 2015 03:06PM
February 19, 2015 04:17PM
February 21, 2015 07:01PM
February 14, 2015 11:39PM