Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-01-11 : 08:30:48
|
Max writes "Here are my tables and their PK and FK, I need to know how to INNER JOIN all four tables together for a recordset.
Products
----------
ProductId(PK)
ProductDesc
ProductCode
ProductSize
ProductColor
ProductPrice
Sizes
-----------
SizeId (PK,FK)
Size1
Size2
Size3
Size4
Colors
-----------
ColorId (PK,FK)
Color1
Color2
Color3
Color4
Prices
-----------
PriceId (PK,FK)
Price1
Price2
Price3
Price4
How do I go about doing this? I had no problem joining 2 together like this:
SELECT *
FROM Products INNER JOIN Sizes ON Products.ProductSize = Sizes.SizeId
Thanks in advance for any help.
Max Fraser
http://www.doorway27.com/" |
|
|
|
|
|
INNER JOIN multiple tables to one table