Find songs that I dont like
Hi, I have a problem that I can't find any answer to.
I have 2 tables, one with songs users like and one with songs
Looks like this:
Table likes:
track_id | user_id
Table tracks
track_id | name
I want to find all the rows in the table likes that one user don't like. Then Join with table tracks. But how do I find all the rows that has the same track_id as all the rows that has the user_id?
Subject
Written By
Posted
Find songs that I dont like
February 20, 2010 05:33PM
February 20, 2010 05:56PM
February 21, 2010 04:20AM
February 21, 2010 08:48AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.