Join Within table's Column

Analyst_SQL 3,551 Reputation points

i want to join column within table ,below is data

Create table #Concategory (Cat_ID int,Cat_name varchar(50),Port_ID int,Acc_type varchar(50))  
insert into   #Concategory values (1,'Akhter','','Port')  
insert into   #Concategory values (2,'Karchi','','Port')  
insert into   #Concategory values (3,'Pakistan',1,'Location')  
insert into   #Concategory values (4,'Iran',2,'Location')  
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,884 questions
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,563 questions
{count} votes

0 additional answers

Sort by: Most helpful