SQL Query required from epxert

I have an issue to query from same table to fetch some data select GuestNote,FName,LName,GuestID,[login to view URL] from Ondemands inner join Users on OnDemands.UserID=[login to view URL] where users.userid=3 and users.password='4201' and status='1' this return : FName,LName for userID=3 and return the GuestID which has FName,LName from same UserTable so I need to fetch FName,LName for the GuestID which is saved as userID in users Table