Re: Help with query (getting from two tables)

[Jay Pipes]

I gather you want to return all definitions, even if they have no examples? If this is the case, you can use a LEFT JOIN with an IFNULL() function to "fill in the blanks":

SELECT
t.id
, t.japanese
, t.furigana
, t.meaning
, IFNULL(e.ex_jpn, 'No example') as 'ex_jpn'
, IFNULL(e.ex_eng, 'No example') as 'ex_eng'
FROM tango t
LEFT JOIN examples e
ON t.japanese = e.japanese
WHERE t.id = 'x';

Jay Pipes
Community Relations Manager, North America, MySQL Inc.

Got Cluster? http://www.mysql.com/cluster
Personal: http://jpipes.com