[ic] $db-->query inner join

[jimbo]

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


-- 
Jim Brewer
Sound Images
12 Whins Close
Camberley
Surrey
GU15 3NW
T +44 (0) 1276 64405
E jimbo at soundimages.co.uk
W http://www.soundimages.co.uk/

------------------------------------------------------------------------
The information in this email is confidential and the contents are not
to be disclosed to anyone other than the addressee, except with their
permission. The opinions expressed represent those of the individual and
not necessarily those of Sound Images. If received in error please
advise the sender and remove from your system.

Sound Images does not guarantee this message, or any attachments, are
free from viruses or other defects.
------------------------------------------------------------------------