Is it possible to have the following situation:
Schema:
id
first
last
optional_id
I want to do a select like this:
SELECT D.id, D.first, D.last, D.optional_id, db1.first, db1.last
FROM db1 AS D
LEFT JOIN db1 ON D.optional_id=db1.id;
and have it return:
|id|first|last|optional_id|first|last|
"Graeme B. Davis" wrote:
>
> Is it possible to have the following situation:
>
> Schema:
>
> id
> first
> last
> optional_id
>
> I want to do a select like this:
>
> SELECT D.id, D.first, D.last, D.optional_id, db1.first, db1.last
> FROM db1 AS D
> LEFT JOIN db1 ON D.optional_id=db1.id;
>
>
