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 |
|
rocketscience
Starting Member
3 Posts |
 Posted - 2001-07-26 : 09:43:42
|
| I have 3 tables:MakeModelInventoryMake contains: MakeID(int,key) and MakeName(varchar)Model contains: ModelID(int,key),MakeID(int),ModelName(varchar)Inventory contains VehicleID(int,key),Make(int), Model(int), Color(varchar),Title(varchar), Description(varchar)I need help with an inner join query that selects all from inventory wheremodel = something and that will connect Make(in inventory) to MakeName(inMake) and Model(in inventory) to ModelName(in Model).This is where I am stuck....SELECT *FROM inventory inner join make on inventory.make = make.makeidWhere model = 1This works for returning everything but the model name.... how can I add:inner join model on inventory.model = model.modelid to the above query?ChrisLearn to share and we all learn. |
|
|
|
|
|
Query help???