[ic] $db-->query inner join

Sam Batschelet sam at westbranchresort.com
Tue Mar 10 15:07:24 UTC 2009

Been trying to do an inner join query with no luck from the docs this should
be working but no go any ideas?

my $q = $db->query({

sql => 'SELECT sum(quantity) FROM inventory INNER JOIN variants WHERE
inventory.sku = variants.code and variants.sku=$sku',


More information about the interchange-users mailing list