Dear Friend,
I will suggest you to write the query in sql server itself and run at the same time, it will let you know the error if you passing through, and i think just copy the codes written in the fronthand and just paste to the sql server and just, follow the errors and you would like to learn the more as you indulje to write more queries there..
Regds
Aziz
azizonin
Last Activity: Oct 29 '08, 02:16 AM
Joined: Oct 24 '08
Location:
-
/*i want to join rows within same table
eg
pid name rollno
1 a 123
2 b 456
1 j 789
2 h 752
two students working on same project
i want to get table of this type
i used self join for this but it doesnt work
pid name rollno rname rrollno
1 a 123 j 789
plz suggest me */
Dear Friend try the below query it will work.
you can use the...Leave a comment:
No activity results to display
Leave a comment: