Thread SELECT COUNT() (8 answers)
Opened by Froschpopo at 2007-02-07 11:22

pq
 2007-02-07 13:33
#35224 #35224
User since
2003-08-04
12209 Artikel
Admin1
[Homepage]
user image
[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: Wiki:Wie frage ich & perlintro Wiki:brian's Leitfaden für jedes Perl-Problem

View full thread SELECT COUNT()