CODEWITHSUNDEEP
sqloracle-databasejoinoracle-sqldeveloper
Poena
Poena

Reputation: 79

SQL Query Results Using Joins

I'm trying to do this query to display the names of the stores and the quantity of each book sold with only using joins but I tried to use

SELECT DISTINCT x.stor_name, t.title, s.qty
FROM stores x
INNER JOIN discounts d
ON x.stor_id=d.stor_id
INNER JOIN salesdetail s
ON d.stor_id=s.stor_id
INNER JOIN titles t
ON s.title_id=t.title_id
ORDER BY s.qty desc;

but that only displayed one of the stores results set for 'Bookbeat'.

I tried to use Left, Right & Full Outer joins to no avail so I'm wondering how I would go about doing that query to display the names for the other stores that are not displaying their result set. As there is 7 stores and only 1 is displaying it's results.

The link is a pastebin to the database.

And this is the schema.

Upvotes: 0

Views: 61

Answers (1)

Pxtl
Pxtl

Reputation: 964

It's hard to say without more information about your schema - it strikes me as wrong-ish that you're joining to discounts only on stor_id. I'd expect discounts to be applied to different titles, not store-wide... and I wouldn't expect discounts to be always-enabled. Try running it without the discounts inner join. Futzing around with "Distinct" and outer joins is almost always the wrong approach with things like this

I see from your profile you're a first-year. Is this schoolwork? How do I ask and answer homework questions?

Upvotes: 2

Related Questions