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....

Answer 1

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

 

Answer 2

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

Answer 3

Hi Manish,

 

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