Query syntax: multiple foreign keys

2002-01-12 Thread =James Birkholz=
. James Birkholz Admin of Posen-L mailing list website - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL

RE: Query syntax: multiple foreign keys

2002-01-12 Thread =James Birkholz=
all the time and need to get a handle on this. If I need to describe the conditions better, I will be happy to. Thanks in advance for any suggestions. James Birkholz Admin of Posen-L mailing list website - Before posting

Re: Query syntax: multiple foreign keys

2002-01-12 Thread =James Birkholz=
with the same name were qualified with the table names? TIA, James Birkholz Admin of Posen-L mailing list website (Here is some more info, if it helps:) This is for a genealogy website. I have 3 tables involved: a Researcher2Languages linking table that contains 0 or more records for every

RE: Query syntax: multiple foreign keys

2002-01-12 Thread =James Birkholz=
Wow, our posts crossed in the mail and you suggested the same approach that I discovered independently! (Great minds think alike, right?) I'm working remotely, the server is many states away, and I don't have a local developement environment. I'm modifying the actual working site, though I try to