I have this join sql statement but i cant seem to get the output that i want : SELECT * FROM tblcheck as ch 
INNER JOIN 
rooms as r on ch.room_id = r.room_id
INNER JOIN
roomtype as c on c.RoomType_id = r.RoomType_id
INNER JOIN
guest as g on g.room_id = ch.room_id


the i output i want is to display this

Guest Name || Room Name || Roomtype || Check-in Date and Time

but i have an error in the guest name. It displays everyone in the Guest Table :( Please help me