Sql Help

[klassicd]

I know its the wrong board but i need some quick help.

Anyone know how to select userid from table2 where userid doesnt exsist in table1?

Anyone know how to select from table2 where userid is in more than one row.


Im trying to find where these extra userid's came from.

[Hierophant]

I am assuming you are using MySQL. You would have to pull both tables into an Array and step through them in the language of your choice.

If you are not using MySQL you can use a subselect like:

SELECT userid FROM table2 WHERE userid NOT IN (SELECT userid FROM table1)

[qslack]

Likewise for the second one. If you are not using MySQL:

SELECT userid FROM table1 WHERE userid IN (SELECT userid FROM table1);

[sylow]

Anyone know how to select userid from table2 where userid doesnt exsist in table1?

select * from table2
LEFT JOIN table1 ON table2.userid = table1.userid WHERE table1.userid is NULL
---------------------------

Anyone know how to select from table2 where userid is in more than one row.

SELECT userid, count(userid) as useridcount FROM table1 GROUP BY userid HAVING useridcount > 1
---------------------------------

[klassicd]

Thanks sylow. Just what i needed.