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

[Sam Batschelet]

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.