Newbie SQL Query problem?
I'm new at this, so bear with me :-)
I'm trying the following query in PHP with MySQL:
$sqlFull = "SELECT feed_items.id AS feedID, store_products.id AS storeID";
$sqlFull .= " FROM store_products";
$sqlFull .= " FULL JOIN feed_items";
$sqlFull .= " ON master_item_id=feed_items.id";
If I run it like that then I get an error:
Unknown column 'store_products.id' in 'field list'
If I change "store_products.id" to just "id" it says:
Column 'id' in field list is ambiguous
|All times are GMT. The time now is 05:58 PM.|
Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.1.0