Data slection based on multiple conditions

Replies

• 

  yudi

  Re: data slection basd on multiple conditions
  
  try using OR operator coz as per my knowledge
  different conditions in where clause are seperated by OR operator......
• 

  esakiraja

  Think this below eg will help u...
  
  Eg: select * from tablename where primarykey(column) = 'value'
  and column2 = 'value'
  and column3 = 'value'
• 

  Itanium

  select * from table
  where col1 = 'value1' and
  col2 = 'value2' and
  col3 = 'value3';
  
  this should be the query if all the columns are holding string data.
  If any column is holding numeric data, then you dont need to specify the value within quotes.
  
  Can you post your exact code for us to analyse ?