sql query to get data from two tables

Question

I have two tables

In table 1 I have

movie_id, movie_name

In table_2 I have

movie_id,movie_genre

Now I want to know the the names of movie which belongs to particular genre

What should my query look like?? Thanks

Mark Byers · Accepted Answer · 2012-03-08 18:26:36Z

3

SELECT movie_name
FROM table1
JOIN table2 USING (movie_id)
WHERE movie_genre = 'some_genre'

answered Mar 8, 2012 at 18:26

Mark Byers

844k202 gold badges1.6k silver badges1.5k bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Sindre · Accepted Answer · 2012-03-08 18:26:38Z

2

Something like this:

SELECT movie_name
FROM table1 AS T1, table_2 AS T2
WHERE movie_genre='action' AND T1.movie_id=T2.movie_id

answered Mar 8, 2012 at 18:26

Sindre

3,9602 gold badges28 silver badges39 bronze badges