Display data from two tables into one gridview through datasource

Could you please share some sample data for both tables so that we can build a query

Sample Persdata Table

pno    name          coy      appt 

136a  ak singh     it1        sys admin

142k  ravi k          it2        sys admin

144h  ss nair        it1        asst sys admin

132P  Hussain k   it3         mech engr      sample qual(table) pno      qual             grading recommendation

136a    ccna                 A           KKLE  

142k    ddcn                 B           

144h    ccna                 A           KKCT

132p    btech(mech)    D           KKME

136A    DDCN               A           

142K    CCNA               B           KKCT

144H    BTECH(CS)      A

132P    BASIC AUTO    A   

THE PERSDATA IS HAVING A PERSONS NUMBER ONE TIME AND IN QUAL TABLE ONE PERSON HAS MORE THAN TWO ROWS because he had done more then one course

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

gives error

Syntax error in FROM clause.

Try this and check

select t1.pno,t1.name,t1.coy,t.appt,t2.qual,t2.grad,t2.recommandation from table t1 ,table t2 where t1.pno= t2.pno

group by t1.pno,t1.name,t1.coy,t.appt,t2.qual,t2.grad,t2.recommandation