If the fields are all integers then it is:
>SELECT HouseID FROM Search WHERE CountryID=2 AND PriceID=3 AND (FacilityID=5)
Rick
At 07:12 PM 3/13/01 -0800, Dennis Gearon wrote:
>I never have luck putting single quotes around anything but strings, or
>column names when called for. You might try
I never have luck putting single quotes around anything but strings, or
column names when called for. You might try your SELECT statement
without 's
>Query 1 :
>
>(I only want result on houses which are in country 2 and in price 3 and
>facility 1 must be included on the spot)
>
>I've used :
>
2 matches
Mail list logo
