View Single Post
Old 07-01-2011, 03:01 PM   #1 (permalink)
RallanToo
The Visitor
 
Join Date: Jul 2011
Posts: 1
Thanks: 0
RallanToo is on a distinguished road
Default Newbie SQL Query problem?

Hi

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

Help?
RallanToo is offline  
Reply With Quote