I hate when somebody put in Subject line something like I just did but after 15 minutes to
try to be specific just with one short sentence - I gave up. So, you can hate me - I
understand (though, help with my problem too) :-)
I have let say 3 tables people, organization, addresses. and they are linked to each other
with column person_id.
to select person by specified person_id it's not big deal, really simple. though, I wonder
how can I select records from these three tables but somehow marked which table it
belongs?
e.g.
select p.first_name, p.last_name, p.status, p.date_registered, o.org_id, o.org_name,
o.org_department, a.addres1, a.address2, a.city, a.state, a.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
I need somehow, together with result data, info which table data belogs?
e.g.
not exactly this way but something like this:
$data = array(
'people' => array('lamp', 'lists', 1, '2008-12-12'),
'organization' => array(56, 'Lamp List', 'web'),
'addresses' => array('123 Main St.', 'Toon Town', 'NY', '12345')
}
thanks for any help.
-afan
