Opened by esskar at 2006-09-26 10:47
User since
2003-08-04
12209 Artikel
Admin1
![[Homepage]](/battie/theme/default/homepage.gif)
2003-08-04
12209 Artikel
Admin1
mir faellt grad kein besserer weg als UNION ein:
[sql]SELECT w1.user_id,w1.wunsch1 AS wunsch
FROM wuensche AS w1 WHERE w1.user_id =1
UNION
SELECT w2.user_id,w2.wunsch2 AS wunsch
FROM wuensche AS w2 WHERE w2.user_id =1 ...[/sql]\n\n
<!--EDIT|pq|1166357424-->
[sql]SELECT w1.user_id,w1.wunsch1 AS wunsch
FROM wuensche AS w1 WHERE w1.user_id =1
UNION
SELECT w2.user_id,w2.wunsch2 AS wunsch
FROM wuensche AS w2 WHERE w2.user_id =1 ...[/sql]\n\n
<!--EDIT|pq|1166357424-->
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:
Wie frage ich & perlintro brian's Leitfaden für jedes Perl-Problem
lesen:
Wie frage ich & perlintro brian's Leitfaden für jedes Perl-Problem