Displaying (more) Conditional Database Data

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

   Hello,

 My original question was answered in this topic http://forums.webwiz.net/forum_posts.asp?TID=27045&PID=138615#138615

But now I am trying to find a way to display data based on the information entered into two columns instead of just one.

I have tried:

SELECT * FROM table_name WHERE field_name = 'DEPARMENT A', WHERE field_name = 'PRODUCT_TYPE B';

I've also tried it without the comma, without the second  "WHERE" and every variation that I could think of. 

Can anyone help me out?

Thanks!