Thread: Java Query help!!! Please help a beginner!!

I have a class project where I'm responsible for coming up with the following query and I'm not sure where to start... Type of... If/then statement, while loop and so on...

"Write a query that finds users who are similar to a given user (target user), the id of the target user is an input parameter. Users are similar to the target user if they rate the same movies."

There are 3 databases in the project, movies, ratings and tags..

Need help!!

Thanks,

Sy

Welcome to the forum! Please read this topic to learn how to post code in code or highlight tags and other useful info for new members.

Most will want to see what you've tried or what you think the query might be rather than just give you an answer. Please post your code or query correctly using code or highlight tags per the above link.

movies, rating and tags are tables or databases?! And from where are you getting the user names?! At least put your DB structure. But as I see, you'll need more than one query here:
1- Get user name for the given id
2- Get the movie name for the current user id
3- Get user ids who's voted for the movie in step 2
4- Get users using the ids that you got in step 3