Create view test1select grpName from b where grpID=(SELECT a.grpID FROM a INNER JOIN b ON c.usrID0 = a.usrID)
