Re: question about my query....

What is the * supposed to mean? It's certainly invalid syntax.

"jAnO!" wrote:

> Hello,
>
> Despite the help i got on my questions about variables, I've dicided to do
> it with nested queries..... but now i have just one problem
> left...............
> Sql gives me a missing statement error on the following query and I don't
> know what's wrong..
>
> select MUT_TEL_NR_LAAG
> ,MUT_TEL_NR_HOOG
> ,MUT_ROEPNUMMER
> ,MUT_NETNUMMER
> ,MUT_TYPE_NUMMER
> ,MUT_TARIEFCODE
> ,MUT_STATUS_NUMMER
> ,MUT_MUTATIE_TYPE
> ,MUT_MUTATIE_DATUM_TIJD
> ,MUT_HUIDIGE_OPERATOR_ID
> ,MUT_OORSPR_OPERATOR_ID
> ,MUT_HUIDIGE_TCD_CODE
> ,MUT_HUIDIGE_TCR_CODE
> ,MUT_HUIDIGE_SPC_ID_HOST
> ,MUT_OORSPR_SPC_ID_HOST
> ,MUT_HUIDIGE_CENTR_NAAM_HOST
> ,MUT_OORSPR_CENTR_NAAM_HOST
> ,MUT_HUIDIGE_CGB_CODE
> ,MUT_OORSPR_CGB_CODE
> ,MUT_LRI
> ,MUT_VORIGE_OPERATOR_ID
> ,MUT_INITIELE_TCR_CODE
> ,MUT_SOORT_TELEFOON_NRS
> ,MUT_STATUS_CENTRALE_NR_SERIE
> ,MUT_SOORT_DIENST
> from num_current_mutatie
> where ((MUT_NETNUMMER >*= (select PARAMETER_VALUE from NUM_JOB_REQ_DET
> where FK_NUM_BATCHJOBBJD_ATTRIBUTE_I = 'NETNRLAAG1')) AND
> (MUT_NETNUMMER <= (select PARAMETER_VALUE from NUM_JOB_REQ_DET where
> FK_NUM_BATCHJOBBJD_ATTRIBUTE_I = 'NETNRHOOG1')) AND
> (select PARAMETER_VALUE from NUM_JOB_REQ_DET where
> FK_NUM_BATCHJOBBJD_ATTRIBUTE_I = 'NETNRLAAG1') IS NOT NULL)) OR
> ((MUT_NETNUMMER >= (select PARAMETER_VALUE from NUM_JOB_REQ_DET where
> FK_NUM_BATCHJOBBJD_ATTRIBUTE_I = 'NETNRLAAG2')) AND
> (MUT_NETNUMMER <= (select PARAMETER_VALUE from NUM_JOB_REQ_DET where
> FK_NUM_BATCHJOBBJD_ATTRIBUTE_I = 'NETNRHOOG2')) AND
> (select PARAMETER_VALUE from NUM_JOB_REQ_DET where
> FK_NUM_BATCHJOBBJD_ATTRIBUTE_I = 'NETNRLAAG2') IS NOT NULL)) OR
> ((MUT_NETNUMMER >= (select PARAMETER_VALUE from NUM_JOB_REQ_DET where
> FK_NUM_BATCHJOBBJD_ATTRIBUTE_I = 'NETNRLAAG3')) AND
> (MUT_NETNUMMER <= (select PARAMETER_VALUE from NUM_JOB_REQ_DET where
> FK_NUM_BATCHJOBBJD_ATTRIBUTE_I = 'NETNRHOOG3')) AND
> (select PARAMETER_VALUE from NUM_JOB_REQ_DET where
> FK_NUM_BATCHJOBBJD_ATTRIBUTE_I = 'NETNRLAAG3') IS NOT NULL)) OR
> ((MUT_NETNUMMER >= (select PARAMETER_VALUE from NUM_JOB_REQ_DET where
> FK_NUM_BATCHJOBBJD_ATTRIBUTE_I = 'NETNRLAAG4')) AND
> (MUT_NETNUMMER <= (select PARAMETER_VALUE from NUM_JOB_REQ_DET where
> FK_NUM_BATCHJOBBJD_ATTRIBUTE_I = 'NETNRHOOG4')) AND
> (select PARAMETER_VALUE from NUM_JOB_REQ_DET where
> FK_NUM_BATCHJOBBJD_ATTRIBUTE_I = 'NETNRLAAG4') IS NOT NULL));
>
>
> where the * is i get the missing expression error.......
> Can somebody give me a push in the wright direction....?
> Thank's in advance....
>
> Jan
> --
> begin BELGISCH-VIRUS.exe
> Mail me naar al je vrienden en formatteer daarna je harddisk!
> end
Received on Tue Feb 27 2001 - 16:44:04 CST