Query Question (searching two columns)

justchillin · #1 (**permalink**) 03-20-12, 10:18

How can I run a query that searches for a reference number that may appear in two different columns? I want to pull all records for idenification numbers that can also show up in a secondary identification column.

r937 · #2 (**permalink**) 03-20-12, 10:42

Code:

SELECT ...
  FROM ...
 WHERE 'r937' IN ( id_number, secondary_id_number )

justchillin · #3 (**permalink**) 03-20-12, 11:23

Thanks. Worked like a charm.

Can I pull this data from 6 tables at the same time?

SELECT *
FROM DBO.[NG 201107 - 201112]
WHERE '2760561238' IN ([Column 0],[Column 26])

r937 · #4 (**permalink**) 03-20-12, 11:43

sure, using UNIONs

Code:

SELECT *
  FROM DBO.[NG 201107]
 WHERE '2760561238' IN ([Column 0],[Column 26])
UNION ALL
SELECT *
  FROM DBO.[NG 201108]
 WHERE '2760561238' IN ([Column 0],[Column 26])
UNION ALL
...
SELECT *
  FROM DBO.[NG 201112]
 WHERE '2760561238' IN ([Column 0],[Column 26])

justchillin · #5 (**permalink**) 03-20-12, 11:55

Thanks r937!

Internet Services

Web Development

Digital Marketing

Consumer Tech