Thanks, Tianli. I appreciate your reply.

I believe I'm defining the column aliases by using syntax like,

SELECT wf.phone AS work_fax, wp.phone AS work_phone
FROM contact
LEFT JOIN phone AS wf ON wf.contact_id = c.id AND wf.location = 'work AND
wf.phone_type = 'Fax'
LEFT JOIN phone AS wp ON wp.contact_id = c.id AND wp.location = 'work' AND
wf.phone_type = 'Phone'


You said,

> If the column name are same with out define alias in SQL, it will add a
number suffix and the number is will be the index of the columns' sequence.

Is there some other syntax I should be using, rather than the above?

I'm downloading 2.2.2 now and will report my results.