How do i combine 2 db table to another 1

Question

Hello now i have 2 tables in my database which is 'Customer' and 'Pet'

so i now i need to let the customer choose a pet and adopt it..

so how should i do it?? so when the customer adopts a pet, then the customer name and the pet adopted name will be in a new db table?

Rajveer Singh · Answer

Hi Priyaranjan i want this to perform from a front end platform which mean currently i have two gridview on my webpage 1 for Customer table and 1 for Pet table.. so i would like the customer to choose a pet.. so once the customer have choose a pet then it will go into another table where it shows only the customer name and the pet name

Sujeet Suman · Answer

Rajveer I think you should use join to implement this. Please once go through below link. This may help you: http://stackoverflow.com/questions/20404682/sql-insert-into-from-multiple-tables If thsi sis helpful for you then please accept my Answer .

Gowtham K · Answer

Hi Rajveer You can perform it simply by using join query refer this https://social.msdn.microsoft.com/Forums/sqlserver/en-US/9fbc392b-809a-44a9-9c54-47efaf9336e8/get-data-from-two-tables-and-insert-into-third-table-in-sql-server2005?forum=sqlgetstarted

Priyaranjan K S · Answer

Hi Rajveer  How do you intend to perform this operation ? From SQL directly or from a front end platform ?