mysql - Joining two tables and keep dissimilar values -

mysql - Joining two tables and keep dissimilar values -

i have 2 tables, kid , parent, want bring together it. kid table include fields not similar ones in parent table. please find tables construction below:

sitetable:

site | sitename ---------------------- 1 london 2 paris 3 ny

assetstable:

id | site ---------------------- 1 b 1 c 2 d 3 e 5 f null

i want bring together these 2 tables , result:

id | sitename ---------------------- london b london c paris d ny e 5 f null

i tried next code:

select a.id, s.sitename assetstable left bring together sitetable s on (s.site = a.site)

sql fiddle

use isnull sql , ifnull mysql

select a.id, isnull(s.sitename,a.site) assetstable left bring together sitetable s on (s.site = a.site)

check sql fiddle

mysql sql-server-2008 join left-join sqlfiddle