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`);
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