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 |
|
metalhead
Starting Member
1 Post |
 Posted - 2009-03-10 : 12:10:29
|
| I have 3 tables a dvd table which holds all the dvd details a customer table which holds all the customer detals and a wishlist lookup table which holds the custID and dvdID in my asp.net website i have the customer logging in and putting their username into a variable called UserId I now what to on one of the pages query the database and using this vaiable show all the dvd titles the customer has added to the their wish list I kno i think i need to use an inner join to query all 3 of these tables so i can find the cusID of the customers username and find all the records in the wishlist with that custID and then find all the dvd titles where dvdID matches in both the wishlist and dvd tables but i'm not sure how to do this over these tables i've only ever done a query on 1 table before can anyone help me cheers |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-03-10 : 12:15:39
|
| Learn here how to post:http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx |
 |
|
|
|
|
|
query multiiple tables