Join with Same table

SQLServerCentral » Latest topics

Join with Same table

Hi All,
 I have below scenario

There are Two tables:

[code language="sql"]
CREATE TABLE DBO.TBLORDERTYPE
(ID INT IDENTITY(1,1),
TYPE_DESC VARCHAR(20))

CREATE TABLE

more info...