in sql i want to the query i have two table fris table Relastion table and secound table Detalis table ok relation table record nad columb just like column Male and myput record p1, p1,p1 p11,p11,p11,p21,p21, myput record p2,p3,p4,p12,p13,p,14,p22,p23 detail column p_id and fecuture record just like p2,p3,p4,p12,p13,p14,p22,p23 fecuture record bhari,ok,avg,avg,ok,bhari,avg,ok iwant thi out put male p1,p11,p21, and p_id p2,p14,p22 give me the sql query