[ic] $db-->query inner join SOLVED
Gert van der Spoel
gert at 3edge.com
Tue Mar 10 19:42:58 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.
>
>
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
More information about the interchange-users
mailing list