Hi,

I have this following query which works, but i need it to return only the cols. I am asking it to. But its returning all cols in the table. How to get only cols that i am renaming in the query i.e only 5 cols.

Code:
SELECT stocks.*, devbg_products.*,
	stoc_id AS SKU,
	ItemName as ItemTitle,
	stoc_qty AS AvailableQuantity,
	ItemPrice AS RetailPrice,
	ItemDescription AS Description
FROM stocks 
	LEFT JOIN devbg_products ON stocks.stoc_item_id = devbg_products.ItemID;
Please help.

Thanks.