حضرت خواجہ سیدنا معین الدین حسن چشتی سنجاری اجمیری رحمۃ اللہ علیہ

Merge results from multiple tables in SQL Server

ganeshms...

Sir,

I have three tables. All 3 table has different fields

Table1:

c1,c2,c3

Table2:

c4,c5,c6

Table3:

c7,c8,c9

i want all column in single row

ie,my result should be like this,

c1,c2,c3,c4,c5,c6,c7,c8,c9

How to get this?

Mudassar

0 1

You cannot unless you have a Primary Key and Foreign Key relationship

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

3.16.137.217