|Syntactic Confectionery Delight|
joining tables with SQL::Abstractby citromatik (Curate)
|on Jun 11, 2008 at 16:32 UTC||Need Help??|
citromatik has asked for the wisdom of the Perl Monks concerning the following question:
I am trying to build an SQL query with SQL::Abstract but I can't find how to join tables. For example, suppose that I want to get the following SQL query:
This is my SQL::Abstract code:
This, generates the following:
My question is, ┐How can I include the join users.userid=drivers.userid inside the WHERE clause?. This doesn't work:
Because SQL::Abstract treats drivers.userid as a quoted string.
In DBIx::Abstract you can do this by playing with the join field:
But I can't find its equivalent in SQL::Abstract
Does anybody know how to do that?
Thank you very much in advance,