[ic] $db-->query inner join

Bill Carr bill at bottlenose-wine.com
Tue Mar 10 14:44:22 UTC 2009


On Mar 10, 2009, at 11:07 AM, Sam Batschelet wrote:

> 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',
>
> });
Make sure you can run your query in you DB's command line client.


Bill Carr
Bottlenose - Wine & Spirits eBusiness Specialists
(413) 584-0400
http://www.bottlenose-wine.com
  Download vCard




More information about the interchange-users mailing list