Do you mean that you want all units to appear, even if they have items
not defined (like having 4 defined and the other 5 with no value) ?
If is that, you may try using LEFT JOIN, instead of INNER JOIN.
Columns which are not defined will appear NULL (I did not test this):
SELECT u.name, item1.nam
Hello,
Is it possible to have a join condition where the condition is not
always me? Here is my query:
SELECT u.name, item1.name AS item1_name,item2.name AS item2_name,
item3.name AS item3_name,item4.name AS item4_name,
item5.name AS item5_name,item6.name AS item6_name,item7.name AS
item7
