I have a scenario where user signup and fill his basic profile field i.e email,username, password, phone and cnin no. Late after successful signup . i have to show a full page for that user to update his Profile further, that includes his DOB, addresses, party belonging, interest, movies, an other stuff.
How would i have to made a query that return which field against that user id has a value of which is not.
I have two related table having One-one-relationship
TblAppUser and TblUserDetails.
TblAppuser stores basic information such id passwrd username email etc and
tbluserdetials has other fields such as dob, interest, movies etc.