Tuesday, 20 October 2015

How to do inner join

Table name: location
 location_id
location_name

Table name: screen
screen_id
screen_name
location_id

Now inner join
SELECT
    `screen`.`screen_id`
    , `screen`.`screen_name`
    , `location`.`location_name`
FROM
    `advt-client`.`location`
    INNER JOIN `advt-client`.`screen`
        ON (`location`.`location_id` = `screen`.`location_id`);

No comments:

Post a Comment