My table has 4 types of "r1": 'Standard', 'HD', 'HD + DVR', 'None'
There are 3 types of "status": 'NTC', 'Repair', 'In Progress'
All I am trying to do is retrieve all of the rows where r1 = 'Standard' and matches all three of the "status":
SELECT * FROM installs WHERE r1 = 'Standard' AND STATUS = 'NTC' OR STATUS = 'In Progress' ORDER BY building, appointment_date ASC
My results continue to pull all the other types of "r1" (HD, HD + DVR, None) and I cannot figure out for the life of me why. Any input would be greatly appreciated.