Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Joins
Message
From
09/08/2000 08:23:12
Michael Levy
Cincinnati, Ohio, United States
 
 
To
05/08/2000 05:42:47
Achim Huber
BPI-Consult
Mainz, Germany
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Title:
Re: Joins
Miscellaneous
Thread ID:
00401095
Message ID:
00402724
Views:
9
Try it this way:

SELECT a.*, e.title, b.department, d.function, c.apostrophe
FROM table1 a
INNER JOIN table b ON a.b_id = b.id
INNER JOIN table c ON a.c_id = c.id
WHERE a.number = "XXX"

-Mike
Michael Levy
MCSD, MCDBA
ma_levy@hotmail.com
Previous
Reply
Map
View

Click here to load this message in the networking platform