I am building an auction website. Right now, I am building the item description page, that has item details, as well as current bid history. My bids table has a FK of Item_id.
My current query looks something like this:
SELECT bids.Item_id, bids.User_email, bids.Bid_amount, products.*
INNER JOIN products
If you need the
bids data separately from the
products data, then you should use two queries.
One query cannot really be arrange to return different columns for different rows.