return results of same ID from 2 tables
I'm using an opensource database, so it's setup is a bit over my head.
Its basically like this. A persons normal information is in the table
'person_per' There is custom information in the table 'person_custom'
both use 'per_ID' to organize.
select per_ID from person_custom where c3 like '2';
gives my the IDs of people who fit my search, I want to "join" (I think)
their name, phone, ect from the 'person_per' table using the ID as the
"key"(terms I read that seem to fit).
How can I do that in a single query?
No comments:
Post a Comment