I need to get 2 different sets of records from the same lookup table (SystemLookups), but I can't quite figure out how to do it. It's almost like I need two different WHERE clauses. One for "ELIGRULE" and "RULETYPE" for another. Do I need to do this in 2 SQL Statements?

	SELECT ;
		ct.ptpn, ;
		ct.ptSSN AS SSN, ;
		ct.pt_DOB as DOB, ;
		ct.Pt_Name AS FullName, ;
		ct.PtFName AS FName, ct.PtMI AS MI, ct.PtLName AS LName, ;
		er.InsCarr, ;
		ct.CarrierName, ;
		m.DateOfService AS DateOfService, ;
		slpr.Descript AS PatientRule, ;
		er.RuleDesc AS CarrierRuleDesc, ;
		er.RuleType AS CarrierRuleCode, ;
		slpr.Descript AS CarrierRuleType, ;
		er.PeriodDays AS CarrierPeriodDays ;
		FROM cursorTemp ct ;
			JOIN SystemLookups slpr ON CursorTemp.EligRule = slpr.Value ;
			JOIN EligibilityRules er ON CursorTemp.InsCarr = er.InsCarr ;
			JOIN SystemLookups slrt ON er.RuleType = slrt.Value ;
		WHERE UPPER(slpr.FieldName) = 'ELIGRULE' OR ;
		WHERE UPPER(slrt.FieldName) = 'RULETYPE' ;
		INTO CURSOR EligibilityValidation READWRITE