[ic] $db-->query inner join SOLVED

Sam Batschelet sam at westbranchresort.com
Tue Mar 10 20:30:40 UTC 2009

On 3/10/09 2:17 PM, "Peter" <peter at pajamian.dhs.org> wrote:

> my $db = $Db{inventory};
> my $qsku = $db->quote($sku);
> my $ref = $db->query("SELECT SUM(i.quantity) FROM inventory i INNER
> JOIN variants v WHERE i.sku = v.code AND v.sku=$qsku");
> my $quantity = $ref->[0]->[0];

Peter thank you so much this works perfectly great advise, thanks to
everyone for your input and help. 

More information about the interchange-users mailing list