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