[ic] $db-->query inner join

Sam Batschelet sam at westbranchresort.com
Tue Mar 10 16:28:22 UTC 2009

On 3/10/09 10:09 AM, "Stefan Hornburg" <racke at linuxia.de> wrote:

> Sam Batschelet wrote:
>>> No luck translates in which error/log message?
>>> Regards
>>> Racke
>> Error.log
>> Runtime error: Can't call method "query" on an undefined value at (tag
>> 'search_region') line 67
> Make sure that $db is populated.
> Regards
> Racke
Right I was looking at that in the docs but all references show a single

my $db = $Db{products};

In a join I am trying am I wrong in doing this?

my $db = $db{inventory, variants};

my $q = $db->query({

   sql => 'SELECT sum(quantity) FROM inventory INNER JOIN variants WHERE
inventory.sku = variants.code and variants.sku=$sku',


More information about the interchange-users mailing list