> 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
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
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
3 matches
Mail list logo