Alex,
Thursday, May 02, 2002, 5:38:49 PM, you wrote:
A> i have to use a statement like:
A> SELECT CODICE FROM TABSIC WHERE COM=1 AND SEN=1 AND PRI=1
A> AND CODICE<>ALL(SELECT CODICE_TABSIC FROM ARCHIVIO_SICU_MIN WHERE
A> (CODICE_ARCHIVIO=342))
A> but mysql doesn't
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 ?
Tha
