[ic] $db-->query inner join

Stefan Hornburg racke at linuxia.de
Tue Mar 10 14:15:24 UTC 2009


Sam Batschelet wrote:
> Been trying to do an inner join query with no luck from the docs this should
> be working but no go any ideas?
> 
> my $q = $db->query({
> 
> sql => 'SELECT sum(quantity) FROM inventory INNER JOIN variants WHERE
> inventory.sku = variants.code and variants.sku=$sku',
> 
> });
> 

No luck translates in which error/log message?

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