From: Donald Whittaker
I believe you are _asking_ for one thing and
showing an _example_ of another.
Going by the example, the first returned row shows
data from field 'value' in table T2. The second shows
data from field 'value' in table T1 as there is no
matching row in table T2. To do that, you could use
the COALESCE function:
...select id, type, COALESCE(T2.value, T1.value)...
As an Amazon Associate we earn from qualifying purchases.
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.