[ic] $db-->query inner join

[Gert van der Spoel]

> -----Original Message-----
> From: interchange-users-bounces at icdevgroup.org [mailto:interchange-
> users-bounces at icdevgroup.org] On Behalf Of Sam Batschelet
> Sent: Tuesday, March 10, 2009 6:31 PM
> To: interchange-users at icdevgroup.org
> Subject: Re: [ic] $db-->query inner join
> 
> 
> 
> 
> 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};

Well regardless of anything else : $db  is something different than $Db ... 

CU,

Gert