SQL/Array

[weazy]

I have a table that has a complete set of labels. I have another table that assigns some labels to some users. I want to create a list that prints the complete set of labels and then says whether it has been assigned to the user or not.

currently i do a sql statement to put table one contents into an array: $array[] and then try to select all from table 2, but i cant get the desired output that way ...

table one:
label 1
label 2
label 3
label 4

table two:
user1 | label 1
user2 | label 2

desired output:
label 1 | user1 | yes
label 2 | user1 | yes
label 3 | user1 | no
label 4 | user1 | no

any ideas?

thanks

[void_function]

SELECT t1.label, t2.user FROM table_one AS t1 LEFT JOIN table_two AS t2 ON t2.label=t1.id

I assume table_one has some primary key called 'id', and table_two has foreign key called 'label' point at this id in table_one.

Then, on each row fetched, if field 'user' is NULL it means there is no association with the label in table_two -- which I assume means no user assigned since you didn't present how you track assignments.