index | search | no replies | posting guidelines | help login | register
Index » Products » ASP Report Wizard v2
search this forum:
:: Query With AND Something AND ( Something OR Some) :: (2)Post a New Message | Post a Reply
Jul 19 2005, 10:17 AM
 Query With AND Something AND ( Something OR Some)Post a Reply
 Latitude7ds

View this author's profile Send this author a private message

from: somewhere

How do I get the Wizard to Create Query Like this...
Select * From aData where RefID = 37 AND (AttID = 112 OR AttID = 113 OR AttID = 114)

I want it to return only the rerences with 37 with ALL 112, 113, 114 Attributes

Seems like a simple query.

Jul 19 2005, 1:29 PM
 Re: Query With AND Something AND ( Something OR...Post a Reply
 ghost

View this author's profile Send this author a private message Visit author's homepage

from: Washington, DC

Use the IS IN condition for the Attributes i.e. IS IN(112,113,114)
as shown in the image below

IS IN Filter




-------------------------
Ghost
Pages: (1)   [1]

search this forum: