Better Way to Phrase SQL

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

Can someone tell me a more efficient (or more proper) way to structure the
following SQL code?:

WHERE
column_9 = A AND
column_9 = B AND
column_9 = C;

In essence, how do I make the database look at column_9 once for all three
criteria?
 
How can column_9 = A and B and C ? If you mean, column_9 = A OR column_9 = B
OR column_9 = C, then you can use
column_9 IN (A,B,C)

Hope This Helps
Gerald Stanley MCSD
 
Back
Top