noone <noone@nowhere.com> wrote in
news:c0be99a872d26915da7bafc7d45c7ae6$1@somehostou tintheEther.com:

> A general rule is to explicitly specify each column in each field.
> One method is a Left Outer Join.
>
>
> select a.id, a.data1,a.data2,b.data1,b.data2 from
> tablea a left outer join tableb b on a.id=b.id where a.id like
> ('$searchterm')
>
> b.data1 and b.data2 will be NULL if there is no data from items table.

Works great, thanks.