RE: On querying a TB with FK's

2005-02-14 Thread Dave Watts
> Thanks, that was a good explanation. One detail, though: I > didn't mention this before, but I have a linking table > because one of my relationships is many to many: > > Table: WordTypeLinking > Field 1: Word FK > Field 2: Type FK > > Does a linking table affect how things work, or can I jus

RE: On querying a TB with FK's

2005-02-14 Thread Roberto Perez
At 10:55 AM 2/14/05, Matthew Walker wrote: >What you're looking for is an inner join. Thanks, that was a good explanation. One detail, though: I didn't mention this before, but I have a linking table because one of my relationships is many to many: Table: WordTypeLinking Field 1: Word FK Fie

RE: On querying a TB with FK's

2005-02-13 Thread Matthew Walker
What you're looking for is an inner join. Ben Forta's "Teach Yourself SQL in 10 Minutes" is a good intro to SQL. SELECT * FROM( [table 1] INNER JOIN [table 2] ON [table 1].pronunciation = [table 2].pronunciation ) INNE