SELECT campus FROM campuses WHERE LOCATION  =  "Northridge" AND county  =  "Los Angeles" UNION SELECT campus FROM campuses WHERE LOCATION  =  "San Francisco" AND county  =  "San Francisco"
Find the name of the campuses that is in Northridge, Los Angeles or in San Francisco, San Francisco.
SELECT campus FROM campuses WHERE LOCATION = `` Northridge '' AND county = `` Los Angeles '' UNION SELECT campus FROM campuses WHERE LOCATION = `` San Francisco '' AND county = `` San Francisco ''
select campus from campuses where location = value and county = value union select campus from campuses where location = value and county = value
Find the name of the campuses that is in Northridge , Los Angeles or in San Francisco , San Francisco .