>-----Original Message-----
>From: Andy Shellam [mailto:andy-lists@stripped]
>Sent: Wednesday, December 17, 2008 3:29 PM
>To: Lamp Lists
>Cc: mysql@stripped
>Subject: Re: need help with query...
>
>Hi Afan
>
>Why not prefix your field names with the table name?
>
>select
> p.first_name AS person_first_name,
> p.last_name AS person_last_name,
> p.status AS person_status,
> p.date_registered AS person_date_registered,
> o.org_id AS organization_org_id,
> o.org_name AS organization_org_name,
> o.org_department AS organization_org_department,
> a.addres1 AS addresses_address1,
> a.address2 AS addresses_address2,
> a.city AS addresses_city,
> a.state AS addresses_state,
> a.zip AS addresses_zip
>from people p, organization o, addresses a
>where p.person_id=123 and o.person_id=p.person_id and
>a.person_id=p.person_id
>
[JS] That would only retrieve a person_id if it is all three tables. I'm not
sure that's what is wanted.
