Multiple column query

D

daddydoop

How do i write a query to cover 5 columns. The data i
need could be in any of 5 columns. I need to show all
rows where the data could be.
 
K

Ken Snell

Are you sure that your table structure is normalized? Your problem statement
suggests that it isn't, and that makes writing queries very difficult to do.

You could write a "WHERE" criterion expression for each "column" (field,
actually) that will select that record if the value is in that field; be
sure to put OR operator between each criteria so that only one needs to be
true for the record to be selected.
 
Top