"Alex" <[EMAIL PROTECTED]> schrieb im Newsbeitrag news:<aatd8o$1jhk$[EMAIL PROTECTED]>... > i have to use a statement like: > SELECT CODICE FROM TABSIC WHERE COM=1 AND SEN=1 AND PRI=1 > AND CODICE<>ALL(SELECT CODICE_TABSIC FROM ARCHIVIO_SICU_MIN WHERE > (CODICE_ARCHIVIO=342)) > > but mysql doesn't support inner select. > > What statement should i use instead of this one ? > > Thanks... > Alex.
Here's how I'd do that : SELECT TS.CODICE, ASM.CODICE_TABSIC FROM TABSIC TS WHERE TS.COM=1 AND TS.SEN=1 AND TS.PRI=1 AND TS.CODICE<>ALL LEFT JOIN ARCHIVIO_SICU_MIN ASM WHERE ASM.CODICE_ARCHIVIO=342 This is a blind guess - haven't tried it - , maybe it'll work for you... regards, marc --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
