Thread SELECT COUNT()
(8 answers)
Opened by Froschpopo at 2007-02-07 11:22
[sql]SELECT defaultusers.name, IF(sessions.uid IS NOT NULL, "Yes!", "No")
FROM defaultusers LEFT JOIN sessions ON defaultusers.id = sessions.uid LIMIT 0, 10[/sql] wie war das noch mit den sql-grundlagen?\n\n <!--EDIT|pq|1170848043--> Always code as if the guy who ends up maintaining your code will be a violent psychopath who knows where you live. -- Damian Conway in "Perl Best Practices"
lesen: ![]() ![]() |