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

[Gert van der Spoel]

> 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.
> 
> 
Tip: next time post a larger chunk of what you are wanting to achieve, or
put it on for example:
http://www.paste.me.uk/

And I stand corrected on the quote part, realized it after I sent it :)

CU,

Gert