Forums

This topic is locked

Newbie help with SQL!

Posted 26 Sep 2001 13:08:39
1
has voted
26 Sep 2001 13:08:39 Dee Hon posted:
Hi again!

I'm creating a table where i have filtered for 'A' in Category. I have a '1' and '2' list in Quantity. How do i exclude '1', or just filter for '2'?

Hope you can help
Thanks
Dee <img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle>

Replies

Replied 26 Sep 2001 16:06:33
26 Sep 2001 16:06:33 Viktor Farcic replied:
WHERE Category = 'A' AND Quantity &lt;&gt; 1


<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
Hi again!

I'm creating a table where i have filtered for 'A' in Category. I have a '1' and '2' list in Quantity. How do i exclude '1', or just filter for '2'?

Hope you can help
Thanks
Dee <img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle>
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>

Replied 26 Sep 2001 16:14:06
26 Sep 2001 16:14:06 Dee Hon replied:
Thanks, it works!

Dee <img src=../images/dmxzone/forum/icon_smile_wink.gif border=0 align=middle>

Replied 26 Sep 2001 16:25:36
26 Sep 2001 16:25:36 Dee Hon replied:
Just one more thing!

After doing - WHERE Category = 'A' AND Quantity &lt;&gt; 1, how would i filter for one 'A', if there are more then one showing?

Thanks
Dee <img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle>


Edited by - dhon on 09/26/2001 16:26:14

Reply to this topic