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

Stefan Hornburg (Racke) racke at linuxia.de
Tue Mar 10 19:55:36 UTC 2009


Gert van der Spoel wrote:
>> 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/

Or use another pastebin if this one thinks of you as a false
positive.

Regards
	Racke

-- 
LinuXia Systems => http://www.linuxia.de/
Expert Interchange Consulting and System Administration
ICDEVGROUP => http://www.icdevgroup.org/
Interchange Development Team




More information about the interchange-users mailing list