Со вложенными запросами еще не сталкивался - буду рад любой помощи - спасибо.
Пытаюсь сделать так:
SELECT *
FROM `tabl`
WHERE coll IS NOT NULL IN (SELECT * FROM `tabl` WHERE coll2='3'
ORDER BY id DESC
LIMIT 5)
Но что то пока не выходит
SELECT *
FROM `tabl`
WHERE coll IS NOT NULL IN (SELECT * FROM `tabl` WHERE coll2='3'
ORDER BY id DESC
LIMIT 5)
select * from tabl where coll is not null order by id desc limit 5
Цитата (kaww @ 6.02.2013 - 16:49) |
Зачем здесь вложенный запрос?select * from tabl where coll is not null order by id desc limit 5 |
SELECT * FROM `tabl` WHERE coll2='3' IN
(SELECT * FROM `tabl` WHERE coll IS NOT NULL)
select * from tabl where coll is not null and coll2=3 order by id desc limit 5