PPCC
May 25th, 2004, 11:55 AM
Hi friends,
I am stuck in solving the sql query.PI am not good at sql query,Please give me the solution ion this.
In my table, there are 3 fields say MainId, Name and parentId.
MainId is auto increment field and ParentId store the value of MainId.
a) Now I want to find the name and their parentId
b) Count of ParentId for the mainId.
How do I get in sql query.
Thanks & Regards
PPCC
I am stuck in solving the sql query.PI am not good at sql query,Please give me the solution ion this.
In my table, there are 3 fields say MainId, Name and parentId.
MainId is auto increment field and ParentId store the value of MainId.
a) Now I want to find the name and their parentId
b) Count of ParentId for the mainId.
How do I get in sql query.
Thanks & Regards
PPCC