I am trying to SELECT WHERE IN SELECT, what I am I doing wrong?
Posted
by Yaqoub Ghanem
on Stack Overflow
See other posts from Stack Overflow
or by Yaqoub Ghanem
Published on 2010-06-01T16:11:06Z
Indexed on
2010/06/01
16:13 UTC
Read the original article
Hit count: 123
mysql
SELECT *
FROM seriallog
WHERE lastevent
IN (SELECT GROUP_CONCAT(CONCAT(' \'', eventid
, '\'')) FROM permissions
WHERE permissions
.userpkid
= 1)
© Stack Overflow or respective owner