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.
SELECT stocks.*, devbg_products.*,
stoc_id AS SKU,
ItemName as ItemTitle,
stoc_qty AS AvailableQuantity,
ItemPrice AS RetailPrice,
ItemDescription AS Description
LEFT JOIN devbg_products ON stocks.stoc_item_id = devbg_products.ItemID;