SQL Server 2005 question self join query
Home > IT Answers > SQL Server > SQL Server 2005 question self join query
Kotnimahesh
5 pts.
0
Q:
SQL Server 2005 question self join query
SQL Server 2005, SQL Server Query, SQL Server tables
I have one table that name is TblCategory on that 2 columns are CategoryName another column name is UpperCategoryID
my table is like this
CategoryName UpperCatID
------------ -----------
Book Commerce
Commerce Accounting
Science Math
Commerce B.O.
Material Pen
Pen Link
Pen Renolods

I want ouput like
CategoryName
------------
Book
Material
ASKED: Aug 5 2009  10:36 AM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
Kotnimahesh
5 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
Last Answered: Aug 5 2009  10:36 AM GMT by Kotnimahesh   5 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

Carlosdl   29795 pts.  |   Aug 5 2009  10:48AM GMT

Could you please explain your requirement ?

What is the logic behind the output you expect ? why did you titled your question “Sqlserver 2005 question self join query ?

Thanks,

 
0