Confirmed users
675
edits
(→example: Deutsch :)) |
m (→example) |
||
Line 118: | Line 118: | ||
select a.id, g.localized_string as greeting, d.localized_string as danger | select a.id, g.localized_string as greeting, d.localized_string as danger | ||
from ((a join translation as g on a.greeting = g.id) | from ((a left outer join translation as g on a.greeting = g.id and g.locale = 'en-us') | ||
join translation as d on a.greeting = d.id | left outer join translation as d on a.greeting = d.id and d.locale = 'en-us') | ||
+----+----------+----------+ | +----+----------+----------+ |