SELECT x.FirstName ,x.SurName,x.OtherNames, x.Gender, x.JambNo,x.ModeOfEntry,x.JmbComb,x.OlevelRstDetails,x.OlevelRst,x.OlevelRst2,x.RegLevel, x.Passport,x.ProgID,x.StateId,x.LGA, x.JambAgg, x.Phone, s.stateID,s.StateAbbr, s.StateName
FROM pstudentinfo_tb x,pstate_tb s WHERE x.ProgID = '' AND x.StateId = s.StateID AND x.RegLevel >= 6 AND x.ModeOfEntry=1Wrong score type passed