data from two tables?
How i can get data from two tables at same time?
Suppose I have two tables
In table 1 I have
In table_2 I have
Now I want to know the the names of movie which belongs to particular genre
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
There are so many ways you might want to get data from two tables that it's hard to pin it down to one example.
For example, suppose you wanted a list of all movie_genre's with a sub-list of the movies associated with that genre. And you want a genre to show even if there is currenly no movie in that genre.
|All times are GMT +1. The time now is 08:22 PM.|
Powered by vBulletin®
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.