Fetching data from two diff tables

Question

I am trying to fetching data from two different tables with different columns without foreign key and show these two table data in single grid view .any body have an idea about this if yes please give me solution for this....

Manish Sharma · Answer

Hi This is my sql query   select Name, gender, Email_Id, Mobile, Present_address, Permenent_Address, Current_Sector, Current_Skill, Qualification_Level1, Specilization, Desired_State, Desired_Location, Resume   select Name,Gender,Email,Mobile,Home_State,Home_Location,Sector,Skill,Qualifaction_Level1,Specilization,Resume,Student_With_institute

Syed Shanu · Answer

Can you provide your both table select query with all comlumn names.

Ashraf Ali · Answer

Hi Manish,   I think you should create a View(Virtual table) to get the data from two different tables with different columns.