Please, please, help me out in rewriting my sub-query to some kind of JOIN for earlier MySQL version:


The query should retrive any availble rooms from the database


MY ATTEMPTED SUB-QUERY: ...

Hi friends, I have very little knowledge of JOINs. Please, help me out in rewriting my sub-query to some kind of JOIN for earlier MySQL version

TABLES IN MY DATABASE:

Room (room_ no, room_...

Hi friends, I have very little knowledge of JOINs. Please, help me out in rewriting my sub-query to some kind of JOIN for earlier MySQL versios.

TABLES IN MY DATABASE:

Room (room_ no, room_...

THIS WAS THE ERROR CODE:

#1064 - You have an error in your SQL syntax. Check the manual that
corresponds to your MySQL server version for the right syntax to use
near
'SELECT R.room_no...

The error is as follows:

SELECT *
FROM room
WHERE room_no NOT
IN (
SELECT R.room_no
FROM room R, Booking B
WHERE R.room_no = B.room_no AND R.room_type = 'single' AND
...

live I mean server

Hi Friends, I need your help.
Whenever I do a query on localhost it retrieves a value, but when I try on live it shows an error? What could be the problem?

Hey folks, I need your help. I stuck with my Database project.
I have five tables on the database: These are

Room, Guest, Booking, Employee and Admin

Room (room_ no, room_ type, price)...