INSERT.... SELECT

[admin]

Should this work?


INSERT INTO HOTELONLINE SET PREFERENCEID=366, HOTELID=D.HOTELID, ROOMID=D.ROOMID, BOOKDATE=D.BOOKDATE, ROOMTYPE=D1.ROOMTYPE
SELECT D.HOTELID, D.ROOMID, D.BOOKDATE, D1.ROOMTYPE
FROM ROOMAVAIL AS D, HOTELROOM AS D1, HOTEL AS D2
WHERE
(D.ROOMID = D1.ROOMID) AND (D.HOTELID=D1.HOTELID) AND (D.HOTELID=D2.HOTELID)


(it doesn't you see!)

Help!

Thanks