[ic] $db-->query inner join

Sam Batschelet sam at westbranchresort.com
Tue Mar 10 16:30:40 UTC 2009




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};

Thanks
-Sam




More information about the interchange-users mailing list