Multiple column query

  • Thread starter Thread starter daddydoop
  • Start date Start date
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.
 
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.
 
Back
Top