[CDBI] coding a join
grigorian at gmail.com
Sun Apr 15 01:18:12 BST 2007
I have 2 tables - "person" and "contact" where each person can have many
contacts. I would like to code the following SQL into Class::DBI:
from person p, contact c
where p.c_id = c.id
and p.id = ?
I think I need set_sql() but since Class::DBI expects the set_sql() query to
return a primary key, I am not sure how to proceed.
TIA for any ideas.
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the ClassDBI