[SOLVED] all inclusive left joins

[Crusader]

How can I do a LEFT JOIN with a where on the right and still include every value of the left table?

 

SELECT i.`integer`, ui.`seen` FROM `integers` AS i LEFT JOIN `user_integers` AS ui ON (i.`integer` = ui.`integer`) WHERE i.`category` = 1 AND ui.`user_id` = 1

 

this results in something like this:

 

integer seen
1       1
2       1
3       1

 

but I want it to display everything regardless of the seen.

 

integer seen
1       1
2       1
3       1
4       null
5       null
6       null

 

The tables are built like this:

 

integers;
integer category
1       1
2       1
3       1
4       1
5       1
6       1
7       2
8       2

user_integers;
id user_id integer seen
1  1       1       1
1  1       2       1
1  1       3       1
1  2       2       1
1  2       1       1

 

Thanks

[Crusader]

Ahhh, never mind. Solved thanks!

 

Moved the user_id condition into the ON.