CODEWITHSUNDEEP
mysqlsqlnested
chripatator
chripatator

Reputation: 13

Nested SQL query using three tables

I got three tables:

Article_Size_Class

Sizes_not_availabe

Size_Table

So I got an Article_ID and now I want to list all the available product lengths from my Size_Table expect the ones listed in the Sizes_not_availabe table.

I tried to do this, but unfortunately it is not working:

SELECT *
FROM Size_Table
WHERE NOT EXISTS
(
SELECT Size_ID
FROM Sizes_not_availabe
LEFT JOIN Article_Size_Class
ON Article_Size_Class.Size_ID = Article_Size_Class.Size_ID
WHERE Article_Size_Class.Article_ID= '00024-002'
)

Thanks for helping!

Upvotes: 0

Views: 26

Answers (1)

Robert Columbia
Robert Columbia

Reputation: 6418

SELECT st.Length FROM Size_Table st
WHERE
st.Size_ID NOT IN
(SELECT sna.Size_ID FROM Sizes_not_available sna INNER JOIN Article_Size_Class asc ON sna.Size_Class=asc.Size_Class WHERE asc.Article_ID= '00024-002')

Upvotes: 1

Related Questions