I have 2 tables with many to many relatioship
tblTitle and tblStyle
I have setup a connecting table tblTitleStyle which contains 2 forein keys TitleID and StyleID to connect the 2 tables.
I can query 2 tables with one to many relatioship using JOINT statement. How do I implement the JOINT statement across tblTitleStyle though? Or is it a wrong aproach altogether, should I use maybe a subquery?
Thanks, Jakub
Does the code below help you out?
Chris
SELECT <insert column names>
FROM dbo.tblTitleStyle ts
|||INNER JOIN dbo.tblTitle t ON t.TitleID = ts.TitleID
INNER JOIN dbo.tblStyle s ON s.StyleID = ts.StyleID
Wow...that was quick and shure works like a charm!..greatly appreciated.
Now I have in adition 2 more tables (names are slightly different...I am in the process of changing them)
Composer and Category
Here is the complete DB scenario:
Title
with many to one relationship to
Composer
Category
and many to many relationship to
Genre (Style before)
I can use one query to SELECT data from Title, Composer and Category:
SELECT t.Title, c.Category, co.Composer
FROM Title t
INNER JOIN Composer co ON t.Index_Composer = co.Index_Composer
INNER JOIN Category c ON t.Index_Category = c.Index_Category
and one query (thanks to you) from the Genre table:
SELECT t.Title, g.Genre
FROM dbo.TitleGenre tg
INNER JOIN dbo.Title t ON t.Index_Title = tg.Index_Title
INNER JOIN dbo.Genre g ON g.Index_Genre = tg.Index_Genre
Can I combine those 2 queries into one to get the result in one form? The problem is that FROM calls for different tables in those 2 queries.
Thanks again...Jakub
I
|||This should do the trick....
Chris
SELECT t.Title, c.Category, co.Composer, g.genre
FROM Title t
|||INNER JOIN Composer co ON t.Index_Composer = co.Index_Composer
INNER JOIN Category c ON t.Index_Category = c.Index_Category
INNER JOIN dbo.TitleGenre tg ON tg.TitleID = t.TitleID
INNER JOIN dbo.Genre g ON g.Index_Genre = tg.Index_Genre
It did, thanks... the query builder in VS web dev produced this convoluted code which didn't work.
Check out www.concertantechamber players.com in few days to see the results...
