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
select t1.pno,t1.name,t1.coy,t.appt,t2.qual,t2.grad,t2.recommandation from table t1 ,tablet2 where t1.pno= t2.pno
group by t1.pno,t1.name,t1.coy,t.appt,t2.qual,t2.grad,t2.recommandation
© COPYRIGHT 2025 ASPSnippets.com ALL RIGHTS RESERVED.