[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