i have a problem in joining two tables the reason is
my first table persdata is having common field as pno (a single row in a particular person) and the second tables is also having pno(having muti entry for a person as this table is of qualification and a person may have more than 3 qualifications and their grading)
sample persdata(table)
pno name coy appt
sample qual(table)
pno qual grading recommendation
i tried my best to do it and not able to proceed
i want the output in a single row as in persdata to a gridview with all the qual combined in one coloumn and all the recommendations combined in one coloumn for a person. i am requesting for you help on this