My impression of right outer join for mssql was that it returned all rows of a table specifed to the right of the join.
But it isnt doing it for me.
i tried this
SELECT item, cost, quantity, category
FROM tbl_items
RIGHT OUTER JOIN tbl_categories ON tbl_items.category = tbl_categories.category
WHER item = 'item'
Ive spent hours. I need the query to return an array for all rows in tbl_categories ( i want to create a list of categories for html select option) and one row for the specified item.
Is this possible?