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 thisIve 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.Code:SELECT item, cost, quantity, category FROM tbl_items RIGHT OUTER JOIN tbl_categories ON tbl_items.category = tbl_categories.category WHER item = 'item'
Is this possible?