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