Forums
This topic is locked
Newbie help with SQL!
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 <> 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>
<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>
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 <> 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
After doing - WHERE Category = 'A' AND Quantity <> 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