Suppose 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
ANSWER
SELECT movie_name
FROM table1
JOIN table2 USING (movie_id)
WHERE movie_genre = 'some_genre'
This is the example to get data from two tables
Destination Wedding Photographer
Top Wedding Photographers
Wedding Photographer Hertfordshire