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?

Here if you see the word "FULL" means nothing but alias of store_products so either remove this word or change "store_products.id" to "FULL.id"