[ic] $db-->query inner join

[Sam Batschelet]

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

> Sam Batschelet wrote:
>> 
>> 
>> On 3/10/09 10:14 AM, "jimbo" <jimbo at soundimages.co.uk> wrote:
>> 
>>>> my $q = $db->query({
>>>> 
>>>> sql => 'SELECT sum(quantity) FROM inventory INNER JOIN variants WHERE
>>>> inventory.sku = variants.code and variants.sku=$sku',
>>>> 
>>>> });
>>> Did you make sure to open the tables in the [perl] tag?
>>> 
>>> [perl tables="inventory variants"][/perl]
>>> 
>>> jimbo
>>> ;-)>
>>> 
>> I did it this way is this wrong?  I am trying to not use ITL in this script
>> if possible.
>> 
>> my $db = $db{inventory, variants};
> 
> $Tag->perl({tables => 'inventory'});
> 
> $db = $Db{inventory} # note capital D
> 
> would work if both tables share the same DBI connection.
> 
> Regards
> Racke
Thanks Racke seems to be running the query just curious why I am getting
back an Array is this by design?