Query for two conditions needed

doosti · November 7th, 2004, 04:08 PM

I want to extract data from the database with two conditions on it.

What is the query if i want two where clause in a query.

Means i want to extract the data from the garments table. Means i want to get the data where garments belongs to men and garment type is T-shirts. What will be the query for this?

Is there involved AND? Kindly plz help!

Farzan Q.
BS(TeleCommunication)
Iqra University.

doosti · November 7th, 2004, 04:27 PM

I got the query. I m posting here..may be it could help someone in future.

sql = "SELECT * FROM Garments WHERE Garment_Who Like '"&garment_who&"'AND Garment_Type Like'"&garment_type&"'"

***Garment_Type and Garment_Who are the fields in database.

Farzan Q.
BS(TeleCommunication)
Iqra University.

happygv · November 9th, 2004, 06:24 AM

LIKE operator is used for pattern search. if you are sure that you check for the exact phrase, you can better use = operator. When you use LIKE operator use % before and/or after the phrase.

Code:

sql =  "SELECT * FROM Garments WHERE Garment_Who Like '%"&garment_who&"%'AND Garment_Type Like'%"&garment_type&"%'"

Hope that helps.
Cheers!

_________________________
- Vijay G
Strive for Perfection