snk
Last Activity: Nov 14 '07, 08:11 AM
Joined: Nov 14 '07
Location:
-
I forgot to say that the database is Mysql 5.045 -
im trying to mix 3 queries. I can only 2. please help
hello,
Iam new in MySQL, in fact its my first day but i have stacked for several hours. I have 3 subqueries, i can mix the 2 of them but i get an error for the third one
the first one is
...Code:SELECT room.roomkey FROM room LEFT JOIN Sbooking ON room.roomkey = Sbooking.roomkey WHERE( Sbooking.date BETWEEN '2007-11-14' AND '2007-11-19' ) GROUP BY room.roomkey
No activity results to display
Leave a comment: