locked
how to join two different table in single column in sql RRS feed

  • Question

  • User-1860778605 posted

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

    Tuesday, September 23, 2014 3:02 AM

All replies

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

    Tuesday, September 23, 2014 3:18 AM
  • 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 ......

    Tuesday, September 23, 2014 3:58 AM