
December 11th, 2002, 12:51 AM
|
|
Contributing User
|
|
Join Date: Apr 2007
Location: San Diego, CA
Posts: 65
Time spent in forums: 21 m 12 sec
Reputation Power: 2
|
|
|
Link Table Hell
I have a Link Table associating 2 tables together. I'm having problems joining the information with SQL statements.
Here are my tables:
AUTHOR
id
name
email
ARTICLE
id
title
abstract
body
ART-AUTH LINK TABLE
artid
authid
If I wanted to find out all of the authors' names of a certain article, do I first have to quuery the link table for all the authid's & then use them to query AUTHOR?
Or is it possible to just use one sql statement? That's what I have been trying without any success.
|