I did the sql coding but im not sure if that is the correct way to do it

[Sevim_WebDesign]

can someone tell me if this is the correct sql coding that i did, im not sure if that is the way i do it

what kind of report will be required for one particular hotel? write at least one SELECT statement (queries) per report need to write at least two statement and report but i did one im not sure if that is the correct for one of it can someone help me with this please

SELECT room.type, room.price FROM Room
WHERE hotelname
INNER JOIN Room ON Hotel.hotelNO=Room.hotelNo AND hotelName='Hilton

[molona]

I guess 'Hilton is really ‘Hilton’ (the last quote is not there, probably a bad copy)

I’m sure that you can Google the structure of a SELECT query and compare an example from any book to your own query.

SELECT table1.fieldname1, table1.fieldname2, table2.fieldname1…

FROM table1 INNER JOIN table2 on table2.table1id=table1.table1id

WHERE …

You get the idea

[Sevim_WebDesign]

i tryed everything but couldnt get it right at all

[molona]

Look at your query and look at the order I showed you. Do you see any difference between your query and the right order for a SELECT query? HINT: INNER JOIN is part of the FROM clause

[Sevim_WebDesign]

SELECT h.hotelname, r.roomno, r.price
FROM b.roomNO
INNER JOIN b.booking ON b.roomNo = b.roomNO
WHERE hotelname= ‘Hilton’

do you think this is the correct one

[r937]

[quote=“Sevim_WebDesign, post:5, topic:187441, full:true”]do you think this is the correct one
[/quote]
what happened when you tested it?™

[molona]

@r937

what happened when you tested it?™

Off Topic:

why the TM thing if you don’t mind my asking?

[r937]

@molona

Off Topic:

why the TM thing if you don’t mind my asking?

see Does this work (update + in ) - #11 by r937

[molona]

I see

@Sevim_WebDesign

I think that you suspect by now that your query is wrong.

Remember that you don’t use the name of a field right after FROM. It should be a table. Same right after the INNER JOIN part

Also, it looks like you’re using three tables but you have only created one relationship: table b with itself.

[r937]

[quote=“molona, post:9, topic:187441, full:true”]Also, it looks like you’re using three tables but you have only created one relationship: table b with itself.
[/quote]
he/she is obviously cutting and pasting from somewhere else (edit: and it isn’t here at sitepoint, see Help finding the total income from a booking for a given hotel date - #14 by molona), and hasn’t answered my question (i would’ve pointed out how the error message relates to the query, to teach him/her how to debug)

but when i get no cooperation, and instead guesswork, i sense a student hard up against a deadline with no real interest in learning…

… and that’s when i bail