RE: SQL

Or:
SELECT * FROM amflib/itmrva WHERE ITTYP in('3','4')

SELECT * FROM amflib/itemasa WHERE ITTYP in('3','4')

Nathan Quinones
Custom Systems Corp
973-726-0202 x213
http://www.cussys.com



                    lisa.thomas@Hayss
                    en.com                   To:     mapics-l@midrange.com
                    Sent by:                 cc:
                    mapics-l-admin@mi        Subject:     RE: SQL
                    drange.com


                    02/25/2002 11:03
                    AM
                    Please respond to
                    mapics-l






Not sure what release you're on or whether you have EPDM or not but here's
what I would do:
SELECT * FROM amflib.itmrva WHERE ITTYP = '3' or ittyp = '4'

-----Original Message-----
From: Jim Wiedl [mailto:WIEDLJ@timesaversinc.com]
Sent: Monday, February 25, 2002 10:58 AM
To: mapics-l@midrange.com
Subject: SQL


Can someone send we a sample SQL statement listing the item masters picking
out only item types 3 and 4?



***********************************************************
This email has been scanned for viruses.
***********************************************************

_______________________________________________
This is the MAPICS ERP System Discussion (MAPICS-L) mailing list
To post a message email: MAPICS-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/mapics-l
or email: MAPICS-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/mapics-l.
_______________________________________________
This is the MAPICS ERP System Discussion (MAPICS-L) mailing list
To post a message email: MAPICS-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/mapics-l
or email: MAPICS-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/mapics-l.