query help
Posted: Sat Sep 05, 2009 2:32 am
Hi,
My database table structure is:
PK_ID, category,parentId
I wanted to select parentId, PK_ID, category where PK_ID=9 and then category and PK_ID where parentId = PK_ID
Please help!
Thanks.
My database table structure is:
PK_ID, category,parentId
I wanted to select parentId, PK_ID, category where PK_ID=9 and then category and PK_ID where parentId = PK_ID
Please help!
Thanks.