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', });