MySQL Forums
Forum List  »  General

dsgnews@yahoo.com
Posted by: dsg news
Date: April 18, 2005 09:06AM

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

Room, Guest, Booking, Employee and Admin.

Room (room_ no, room_ type, price)

Guest (guest_ no, Fname, Sname, address,…)

Booking (room_no, guest_no, Fname, Sname, arrival_date,
departure_date, emp_no, user_name, password)

Employee (emp_no, Fname, Sname, uaser_name, password)

Admin (admin_no, fname, Lname, user_name, password)

I used the fallowing query to search for available rooms:

Select *
From Room R
Where R.room_no
NOT IN (Select B.room_no
From R.room_no = B.room_no
And R.room_type = ‘single’
And B.arrival_date = ‘2005-03-16’
And Bdeparture_date = ‘2005-04-19’

Q1. Whenever I do a query on localhost it retrieves a value, but when I try on live it shows an error. Please, tell me what the problem in this query could be?

Q2. Does MySQL use different SQL query such as like PL SQL or is it the similar query?

Q3.Is their any simple query than this.

Thanks for all your help.

Options: ReplyQuote


Subject
Written By
Posted
dsgnews@yahoo.com
April 18, 2005 09:06AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.