how to join two different table in single column in sql

Question

User-1860778605 posted

how to join two different table in single column in sql . any one give some example

Answer 1

User-1618234021 posted

If you mean to join on a common column, then you can use one of the joins in SQL. If you mean other wise, then please explain more and paste the structure of both tables.

Answer 2

User79986525 posted

Hi  Arun,

Try like this 

select (convert(nvarchar, BE.Column1) +' '+ convert(nvarchar,SCL.Column2)) as MergeTwoColumnIntoOne from dbo.TableBE BE 
INNER JOIN dbo.TableSCL SCL ON
BE.ColumnId=SCL.ColumnId

Hope this will help you out ......