[ic] $db-->query inner join

[Sam Batschelet]

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
table

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',


});