[CDBI] Re: coding a join

Arshavir Grigorian wrote:
> 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.

That's incorrect. Please re-read the documentation, specifically these two
sections:

http://search.cpan.org/~tmtm/Class-DBI/lib/Class/DBI.pm#Ima%3A%3ADBI_queries
http://search.cpan.org/~tmtm/Class-DBI/lib/Class/DBI.pm#Single_Value_SELECTs

Hope this helps,
Ed