Expression too Complex

how can use more then one condition in where (sql quire)

Page 1 of 1

9 Replies - 536 Views - Last Post: 07 May 2009 - 01:52 PM Rate Topic: -----

#1 latha123laksh  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 2
  • Joined: 07-May 09

Expression too Complex

Post icon  Posted 07 May 2009 - 01:41 AM

Hai,


i am a new guy .....

am excuting the following qurie but i am getting error like"Expression too Complex"

"SELECT s.[BSC], s.[NPC], s.[GMAC], s.[GMIC], s.[DMAC], s.[DMIC], s.[DISB], s.[TIM], s.[EEF], s.[EPF], s.[EOF], s.[ERF], s.[HRI], s.[HRL], s.[HRU], s.[AUT], s.[ALT], s.[AML], s.[ACH], s.[IAC], s.[SAL], s.[ASG], s.[CSD], s.[CSU], s.[TGT], s.[HDL], s.[HUL], s.[CLR], s.[CTR], s.[CTC], s.[MINHTT], s.[MAXHTT], s.[MAXHTS], s.[TCHFR], s.[SCHFR], s.[CNGT], s.[CNGS], s.[CS], s.[CSR], s.[PRDMHT], s.[PRDMHS], s.[PRDCFR], s.[PRDCNG], s.[HIFLVL], s.[HIFSHR], s.[PRDHIF], s.[PRDBNT], s.[SMBNT], s.[EMBNT], s.[GTUGT], s.[BCSUL], s.[LAPDL], s.[MSSCF], s.[MSSCS], s.[ALFRT], s.[ALHRT], s.[ALSDC], s.[DINHO], s.[DEXDR], s.[RXBAL], s.[RXANT], s.[ITCF], s.[VDLS], s.[MNDL], s.[MNUL], s.[FPHO], s.[ISS], s.[PRE], s.[SBCNF], s.[SBCNH], s.[SBCN], s.[SBCNAF], s.[SBCNAH], s.[RXTA], s.[DEC], s.[IHTA], s.[TTRC], s.[MTTR], s.[DHP], s.[DNP], s.[DLP], s.[UP1], s.[UP2], s.[UP3], s.[UP4], s.[SSW1], s.[SSW2], s.[SSW3], s.[ISW11], s.[ISW12], s.[ISW13], s.[ISW21], s.[ISW22], s.[ISW23], s.[ISW31], s.[ISW32], s.[ISW33], s.[BGSW1], s.[BGSW2], s.[BGSW3], s.[QCATR], s.[QCATN], s.[QCATQ], s.[QCATD], s.[UBL1], s.[UBL2], s.[UBL3], s.[UBL4], s.[UBL5], s.[UBL6], s.[ABL1], s.[ABL2], s.[ABL3], s.[ABL4], s.[ABL5], s.[BL02], s.[BL03], s.[BL04], s.[BL12], s.[BL13], s.[BL14], s.[BL23], s.[BL24], s.[RL02], s.[RL03], s.[RL04], s.[RL12], s.[RL13], s.[RL14], s.[RL23], s.[RL24], s.[EGIC], s.[IEPH], s.[SPL]
FROM tblPerfectBsc AS f, tblAllBsc AS s
WHERE f.[BSC] <> s.[BSC] AND (f.[NPC] <> s.[NPC] OR f.[GMAC] <> s.[GMAC] OR f.[GMIC] <> s.[GMIC] OR f.[DMAC] <> s.[DMAC] OR f.[DMIC] <> s.[DMIC] OR f.[DISB] <> s.[DISB] OR f.[TIM] <> s.[TIM] OR f.[EEF] <> s.[EEF] OR f.[EPF] <> s.[EPF] OR f.[EOF] <> s.[EOF] OR f.[ERF] <> s.[ERF] OR f.[HRI] <> s.[HRI] OR f.[HRL] <> s.[HRL] OR f.[HRU] <> s.[HRU] OR f.[AUT] <> s.[AUT] OR f.[ALT] <> s.[ALT] OR f.[AML] <> s.[AML] OR f.[ACH] <> s.[ACH] OR f.[IAC] <> s.[IAC] OR f.[SAL] <> s.[SAL] OR f.[ASG] <> s.[ASG] OR f.[CSD] <> s.[CSD] OR f.[CSU] <> s.[CSU] OR f.[TGT] <> s.[TGT] OR f.[HDL] <> s.[HDL] OR f.[HUL] <> s.[HUL] OR f.[CLR] <> s.[CLR] OR f.[CTR] <> s.[CTR] OR f.[CTC] <> s.[CTC] OR f.[MINHTT] <> s.[MINHTT] OR f.[MAXHTT] <> s.[MAXHTT] OR f.[MAXHTS] <> s.[MAXHTS] OR f.[TCHFR] <> s.[TCHFR] OR f.[SCHFR] <> s.[SCHFR] OR f.[CNGT] <> s.[CNGT] OR f.[CNGS] <> s.[CNGS] OR f.[CS] <> s.[CS] OR f.[CSR] <> s.[CSR] OR f.[PRDMHT] <> s.[PRDMHT] OR f.[PRDMHS] <> s.[PRDMHS] OR f.[PRDCFR] <> s.[PRDCFR] OR f.[PRDCNG] <> s.[PRDCNG] OR f.[HIFLVL] <> s.[HIFLVL] OR f.[HIFSHR] <> s.[HIFSHR] OR f.[PRDHIF] <> s.[PRDHIF] OR f.[PRDBNT] <> s.[PRDBNT] OR f.[SMBNT] <> s.[SMBNT] OR f.[EMBNT] <> s.[EMBNT] OR f.[GTUGT] <> s.[GTUGT] OR f.[BCSUL] <> s.[BCSUL] OR f.[LAPDL] <> s.[LAPDL] OR f.[MSSCF] <> s.[MSSCF] OR f.[MSSCS] <> s.[MSSCS] OR f.[ALFRT] <> s.[ALFRT] OR f.[ALHRT] <> s.[ALHRT] OR f.[ALSDC] <> s.[ALSDC] OR f.[DINHO] <> s.[DINHO] OR f.[DEXDR] <> s.[DEXDR] OR f.[RXBAL] <> s.[RXBAL] OR f.[RXANT] <> s.[RXANT] OR f.[ITCF] <> s.[ITCF] OR f.[VDLS] <> s.[VDLS] OR f.[MNDL] <> s.[MNDL] OR f.[MNUL] <> s.[MNUL] OR f.[FPHO] <> s.[FPHO] OR f.[ISS] <> s.[ISS] OR f.[PRE] <> s.[PRE] OR f.[SBCNF] <> s.[SBCNF] OR f.[SBCNH] <> s.[SBCNH] OR f.[SBCN] <> s.[SBCN] OR f.[SBCNAF] <> s.[SBCNAF] OR f.[SBCNAH] <> s.[SBCNAH] OR f.[RXTA] <> s.[RXTA] OR f.[DEC] <> s.[DEC] OR f.[IHTA] <> s.[IHTA] OR f.[TTRC] <> s.[TTRC] OR f.[MTTR] <> s.[MTTR] OR f.[DHP] <> s.[DHP] OR f.[DNP] <> s.[DNP] OR f.[DLP] <> s.[DLP] OR f.[UP1] <> s.[UP1] OR f.[UP2] <> s.[UP2] OR f.[UP3] <> s.[UP3] OR f.[UP4] <> s.[UP4] OR f.[SSW1] <> s.[SSW1] OR f.[SSW2] <> s.[SSW2] OR f.[SSW3] <> s.[SSW3] OR f.[ISW11] <> s.[ISW11] OR f.[ISW12] <> s.[ISW12] OR f.[ISW13] <> s.[ISW13] OR f.[ISW21] <> s.[ISW21] OR f.[ISW22] <> s.[ISW22] OR f.[ISW23] <> s.[ISW23] OR f.[ISW31] <> s.[ISW31] OR f.[ISW32] <> s.[ISW32] OR f.[ISW33] <> s.[ISW33] OR f.[BGSW1] <> s.[BGSW1] OR f.[BGSW2] <> s.[BGSW2] OR f.[BGSW3] <> s.[BGSW3] OR f.[QCATR] <> s.[QCATR] OR f.[QCATN] <> s.[QCATN] OR f.[QCATQ] <> s.[QCATQ] OR f.[QCATD] <> s.[QCATD] OR f.[UBL1] <> s.[UBL1] OR f.[UBL2] <> s.[UBL2] OR f.[UBL3] <> s.[UBL3] OR f.[UBL4] <> s.[UBL4] OR f.[UBL5] <> s.[UBL5] OR f.[UBL6] <> s.[UBL6] OR f.[ABL1] <> s.[ABL1] OR f.[ABL2] <> s.[ABL2] OR f.[ABL3] <> s.[ABL3] OR f.[ABL4] <> s.[ABL4] OR f.[ABL5] <> s.[ABL5] OR f.[BL02] <> s.[BL02] OR f.[BL03] <> s.[BL03] OR f.[BL04] <> s.[BL04] OR f.[BL12] <> s.[BL12] OR f.[BL13] <> s.[BL13] OR f.[BL14] <> s.[BL14] OR f.[BL23] <> s.[BL23] OR f.[BL24] <> s.[BL24] OR f.[RL02] <> s.[RL02] OR f.[RL03] <> s.[RL03] OR f.[RL04] <> s.[RL04] OR f.[RL12] <> s.[RL12] OR f.[RL13] <> s.[RL13] OR f.[RL14] <> s.[RL14] OR f.[RL23] <> s.[RL23] OR f.[RL24] <> s.[RL24] OR f.[EGIC] <> s.[EGIC] OR f.[IEPH] <> s.[IEPH] OR f.[SPL] <> s.[SPL]);"

Please give me a solution .....



Thanks & Regards,
Latha123laksh

Attached File(s)



Is This A Good Question/Topic? 0
  • +

Replies To: Expression too Complex

#2 itlee  Icon User is offline

  • D.I.C Head

Reputation: 7
  • View blog
  • Posts: 55
  • Joined: 16-July 08

Re: Expression too Complex

Posted 07 May 2009 - 02:08 AM

Tell us what you data you are trying to retrieve. i.e. "return all records from one table which does not exist in another table"

maybe give some sample data too.

From the SQL, my immediate thoughts are exactly that.

itlee.
Was This Post Helpful? 0
  • +
  • -

#3 AdamSpeight2008  Icon User is offline

  • MrCupOfT
  • member icon


Reputation: 2271
  • View blog
  • Posts: 9,500
  • Joined: 29-May 08

Re: Expression too Complex

Posted 07 May 2009 - 02:15 AM

Wow that sql query is intimidatingly scary.
I think your database may need simplifying.
Was This Post Helpful? 0
  • +
  • -

#4 latha123laksh  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 2
  • Joined: 07-May 09

Re: Expression too Complex

Posted 07 May 2009 - 02:25 AM

Hai,

this is my table with quries.......


tblAllBsc
---------

BSC NPC GMAC GMIC DMAC DMIC DISB TIM EEF EPF EOF ERF HRI HRL HRU AUT ALT AML ACH IAC SAL ASG CSD CSU TGT HDL HUL CLR CTR CTC MINHTT MAXHTT MAXHTS TCHFR SCHFR CNGT CNGS CS CSR PRDMHT PRDMHS PRDCFR PRDCNG HIFLVL HIFSHR PRDHIF PRDBNT SMBNT EMBNT GTUGT BCSUL LAPDL MSSCF MSSCS ALFRT ALHRT ALSDC DINHO DEXDR RXBAL RXANT ITCF VDLS MNDL MNUL FPHO ISS PRE SBCNF SBCNH SBCN SBCNAF SBCNAH RXTA DEC IHTA TTRC MTTR DHP DNP DLP UP1 UP2 UP3 UP4 SSW1 SSW2 SSW3 ISW11 ISW12 ISW13 ISW21 ISW22 ISW23 ISW31 ISW32 ISW33 BGSW1 BGSW2 BGSW3 QCATR QCATN QCATQ QCATD UBL1 UBL2 UBL3 UBL4 UBL5 UBL6 ABL1 ABL2 ABL3 ABL4 ABL5 BL02 BL03 BL04 BL12 BL13 BL14 BL23 BL24 RL02 RL03 RL04 RL12 RL13 RL14 RL23 RL24 EGIC IEPH SPL
BANAN35 3 35 dBm 33 dBm 30 dBm 30 dBm 255 30 s N N N N 4 40 % 60 % 80 % 20 % 70 % 1 1 N N 95 % 4 s 30 s INTER INTER 100 % N 0 5 s 120 min 30 min 40 % 80 % 20 % 20 % 30 100 120 min 60 min 60 min 120 min 4 50 % 120 min 60 min 04-00 23-59 5 s 1 50 % 1 50 % 1020 km/h 3060 km/h 30 % 30 % 15 % N Y 5 dB 65535 min 5 N 9 7 N 255 s Y 12 dB 14 dB 14 dB 7 dB 12 dB 0 5 s 0 10 50 3 6 12 3 6 9 12 20 10 5 20 10 5 20 10 5 20 10 5 20 10 5 25 BLOCK PERIODS 100 BLOCK PERIODS 200 BLOCK PERIODS 400 BLOCK PERIODS 20 20 20 1 1 1 90 % 10 % 10 % 70 % 90 % 21 dB 26 dB 30 dB 20 dB 25 dB 30 dB 24 dB 29 dB 5 dB 3 dB 1 dB 5 dB 3 dB 1 dB 3 dB 2 dB 0 10 15 min
BANBG42 3 35 dBm 33 dBm 30 dBm 30 dBm 255 30 s N N N N 4 60 % 60 % 80 % 20 % 70 % 1 1 N N 95 % 4 s 30 s INTER INTER 100 % N 0 8 s 120 min 30 min 20 % 80 % 20 % 20 % 10 100 240 min 60 min 60 min 120 min 4 50 % 120 min 120 min 08-00 18-00 5 s 1 50 % 1 50 % 1020 km/h 3060 km/h 30 % 30 % 30 % N Y 5 dB 65535 min 5 N 9 7 N 255 s Y 12 dB 14 dB 14 dB 7 dB 12 dB 0 5 s 0 10 50 3 6 12 3 6 9 12 20 10 5 20 10 5 20 10 5 20 10 5 20 10 5 25 BLOCK PERIODS 100 BLOCK PERIODS 200 BLOCK PERIODS 400 BLOCK PERIODS 20 20 20 1 1 1 90 % 10 % 10 % 70 % 90 % 21 dB 26 dB 30 dB 20 dB 25 dB 30 dB 24 dB 29 dB 5 dB 3 dB 1 dB 5 dB 3 dB 1 dB 3 dB 2 dB 0 10 15 min
BANBL19 3 35 dBm 33 dBm 30 dBm 30 dBm 255 30 s N N N N 4 40 % 60 % 80 % 20 % 70 % 1 1 N N 95 % 4 s 30 s INTER INTER 100 % N 0 5 s 120 min 30 min 40 % 80 % 20 % 20 % 30 100 120 min 60 min 60 min 120 min 4 50 % 120 min 60 min 04-00 23-59 5 s 1 50 % 1 50 % 1020 km/h 3060 km/h 30 % 30 % 15 % N Y 5 dB 65535 min 5 N 9 7 N 255 s Y 12 dB 14 dB 14 dB 7 dB 12 dB 0 5 s 0 10 50 3 6 12 3 6 9 12 20 10 5 20 10 5 20 10 5 20 10 5 20 10 5 25 BLOCK PERIODS 100 BLOCK PERIODS 200 BLOCK PERIODS 400 BLOCK PERIODS 20 20 20 1 1 1 90 % 10 % 10 % 70 % 90 % 21 dB 26 dB 30 dB 20 dB 25 dB 30 dB 24 dB 29 dB 5 dB 3 dB 1 dB 5 dB 3 dB 1 dB 3 dB 2 dB 3 10 60 min
BANBM32 3 35 dBm 33 dBm 30 dBm 30 dBm 255 30 s N N N N 4 40 % 60 % 80 % 20 % 70 % 1 1 N N 95 % 4 s 30 s INTER INTER 100 % N 0 5 s 120 min 30 min 40 % 80 % 20 % 20 % 30 100 120 min 60 min 60 min 120 min 4 50 % 120 min 60 min 04-00 23-59 5 s 1 50 % 1 50 % 1020 km/h 3060 km/h 30 % 30 % 15 % N Y 5 dB 65535 min 5 N 9 7 N 255 s Y 12 dB 14 dB 14 dB 7 dB 12 dB 0 5 s 0 10 50 3 6 12 3 6 9 12 20 10 5 20 10 5 20 10 5 20 10 5 20 10 5 25 BLOCK PERIODS 100 BLOCK PERIODS 200 BLOCK PERIODS 400 BLOCK PERIODS 20 20 20 1 1 1 90 % 10 % 10 % 70 % 90 % 21 dB 26 dB 30 dB 20 dB 25 dB 30 dB 24 dB 29 dB 5 dB 3 dB 1 dB 5 dB 3 dB 1 dB 3 dB 2 dB 3 10 60 min
BANBR11 3 35 dBm 33 dBm 30 dBm 30 dBm 255 30 s N N N N 4 40 % 60 % 80 % 20 % 70 % 1 1 N N 95 % 4 s 30 s INTER INTER 100 % N 0 5 s 120 min 30 min 40 % 80 % 20 % 20 % 30 100 120 min 60 min 60 min 120 min 4 50 % 120 min 60 min 04-00 23-59 5 s 1 50 % 1 50 % 1020 km/h 3060 km/h 30 % 30 % 15 % N Y 5 dB 65535 min 5 N 9 7 N 255 s Y 12 dB 14 dB 14 dB 7 dB 12 dB 0 5 s 0 10 50 3 6 12 3 6 9 12 20 10 5 20 10 5 20 10 5 20 10 5 20 10 5 25 BLOCK PERIODS 100 BLOCK PERIODS 200 BLOCK PERIODS 400 BLOCK PERIODS 20 20 20 1 1 1 90 % 10 % 10 % 70 % 90 % 21 dB 26 dB 30 dB 20 dB 25 dB 30 dB 24 dB 29 dB 5 dB 3 dB 1 dB 5 dB 3 dB 1 dB 3 dB 2 dB 3 10 60 min
BANBS17 3 35 dBm 33 dBm 30 dBm 30 dBm 255 30 s N N N N 4 40 % 60 % 80 % 20 % 70 % 1 1 N N 95 % 4 s 30 s INTER INTER 100 % N 0 5 s 120 min 30 min 40 % 80 % 20 % 20 % 30 100 120 min 60 min 60 min 120 min 4 50 % 120 min 60 min 04-00 23-59 5 s 1 50 % 1 50 % 1020 km/h 3060 km/h 30 % 30 % 15 % N Y 5 dB 65535 min 5 N 9 7 N 255 s Y 12 dB 14 dB 14 dB 7 dB 12 dB 0 5 s 0 10 50 3 6 12 3 6 9 12 20 10 5 20 10 5 20 10 5 20 10 5 20 10 5 25 BLOCK PERIODS 100 BLOCK PERIODS 200 BLOCK PERIODS 400 BLOCK PERIODS 20 20 20 1 1 1 90 % 10 % 10 % 70 % 90 % 21 dB 26 dB 30 dB 20 dB 25 dB 30 dB 24 dB 29 dB 5 dB 3 dB 1 dB 5 dB 3 dB 1 dB 3 dB 2 dB 3 10 60 min
BANBT24 3 35 dBm 33 dBm 30 dBm 30 dBm 255 30 s N N N N 4 40 % 60 % 80 % 20 % 70 % 1 1 N N 95 % 4 s 30 s INTER INTER 100 % N 0 5 s 120 min 30 min 40 % 80 % 20 % 20 % 30 100 120 min 60 min 60 min 120 min 4 50 % 120 min 60 min 04-00 23-59 5 s 1 50 % 1 50 % 1020 km/h 3060 km/h 30 % 30 % 15 % N Y 5 dB 65535 min 5 N 9 7 N Y 12 dB 14 dB 14 dB 7 dB 12 dB 0 5 s 0 10 50 3 6 12 3 6 9 12 20 10 5 20 10 5 20 10 5 20 10 5 20 10 5 25 BLOCK PERIODS 100 BLOCK PERIODS 200 BLOCK PERIODS 400 BLOCK PERIODS 20 20 20 1 1 1 90 % 10 % 10 % 70 % 90 % 21 dB 26 dB 30 dB 20 dB 25 dB 30 dB 24 dB 29 dB 5 dB 3 dB 1 dB 5 dB 3 dB 1 dB 3 dB 2 dB 3 10 60 min
BANCR04 3 35 dBm 33 dBm 30 dBm 30 dBm 255 30 s N N N N 4 40 % 60 % 80 % 20 % 70 % 1 1 N N 95 % 4 s 30 s INTER INTER 100 % N 0 5 s 120 min 30 min 40 % 80 % 20 % 20 % 30 100 120 min 60 min 60 min 120 min 4 50 % 120 min 60 min 04-00 23-59 5 s 1 50 % 1 50 % 1020 km/h 3060 km/h 30 % 30 % 15 % N Y 5 dB 65535 min 5 N 9 7 N 255 s Y 12 dB 14 dB 14 dB 7 dB 12 dB 0 5 s 0 10 50 3 6 12 3 6 9 12 20 10 5 20 10 5 20 10 5 20 10 5 20 10 5 25 BLOCK PERIODS 100 BLOCK PERIODS 200 BLOCK PERIODS 400 BLOCK PERIODS 20 20 20 1 1 1 90 % 10 % 10 % 70 % 90 % 21 dB 26 dB 30 dB 20 dB 25 dB 30 dB 24 dB 29 dB 5 dB 3 dB 1 dB 5 dB 3 dB 1 dB 3 dB 2 dB 3 10 60 min


tblPerfectBsc
-------------
BSC NPC GMAC GMIC DMAC DMIC DISB TIM EEF EPF EOF ERF HRI HRL HRU AUT ALT AML ACH IAC SAL ASG CSD CSU TGT HDL HUL CLR CTR CTC MINHTT MAXHTT MAXHTS TCHFR SCHFR CNGT CNGS CS CSR PRDMHT PRDMHS PRDCFR PRDCNG HIFLVL HIFSHR PRDHIF PRDBNT SMBNT EMBNT GTUGT BCSUL LAPDL MSSCF MSSCS ALFRT ALHRT ALSDC DINHO DEXDR RXBAL RXANT ITCF VDLS MNDL MNUL FPHO ISS PRE SBCNF SBCNH SBCN SBCNAF SBCNAH RXTA DEC IHTA TTRC MTTR DHP DNP DLP UP1 UP2 UP3 UP4 SSW1 SSW2 SSW3 ISW11 ISW12 ISW13 ISW21 ISW22 ISW23 ISW31 ISW32 ISW33 BGSW1 BGSW2 BGSW3 QCATR QCATN QCATQ QCATD UBL1 UBL2 UBL3 UBL4 UBL5 UBL6 ABL1 ABL2 ABL3 ABL4 ABL5 BL02 BL03 BL04 BL12 BL13 BL14 BL23 BL24 RL02 RL03 RL04 RL12 RL13 RL14 RL23 RL24 EGIC IEPH SPL
BANAN35 3 35 dBm 33 dBm 30 dBm 30 dBm 255 30 s N N N N 4 40 % 60 % 80 % 20 % 70 % 1 1 N N 95 % 4 s 30 s INTER INTER 100 % N 0 5 s 120 min 30 min 40 % 80 % 20 % 20 % 30 100 120 min 60 min 60 min 120 min 4 50 % 120 min 60 min 04-00 23-59 5 s 1 50 % 1 50 % 1020 km/h 3060 km/h 30 % 30 % 15 % N Y 5 dB 65535 min 5 N 9 7 N 255 s Y 12 dB 14 dB 14 dB 7 dB 12 dB 0 5 s 0 10 50 3 6 12 3 6 9 12 20 10 5 20 10 5 20 10 5 20 10 5 20 10 5 25 BLOCK PERIODS 100 BLOCK PERIODS 200 BLOCK PERIODS 400 BLOCK PERIODS 20 20 20 1 1 1 90 % 10 % 10 % 70 % 90 % 21 dB 26 dB 30 dB 20 dB 25 dB 30 dB 24 dB 29 dB 5 dB 3 dB 1 dB 5 dB 3 dB 1 dB 3 dB 2 dB 0 10 15 min


QUrie
-----

SELECT s.[BSC], s.[NPC], s.[GMAC], s.[GMIC], s.[DMAC], s.[DMIC], s.[DISB], s.[TIM], s.[EEF], s.[EPF], s.[EOF],

s.[ERF], s.[HRI], s.[HRL], s.[HRU], s.[AUT], s.[ALT], s.[AML], s.[ACH], s.[IAC], s.[SAL], s.[ASG], s.[CSD], s.[CSU],

s.[TGT], s.[HDL], s.[HUL], s.[CLR], s.[CTR], s.[CTC], s.[MINHTT], s.[MAXHTT], s.[MAXHTS], s.[TCHFR], s.[SCHFR],

s.[CNGT], s.[CNGS], s.[CS], s.[CSR], s.[PRDMHT], s.[PRDMHS], s.[PRDCFR], s.[PRDCNG], s.[HIFLVL], s.[HIFSHR],

s.[PRDHIF], s.[PRDBNT], s.[SMBNT], s.[EMBNT], s.[GTUGT], s.[BCSUL], s.[LAPDL], s.[MSSCF], s.[MSSCS], s.[ALFRT],

s.[ALHRT], s.[ALSDC], s.[DINHO], s.[DEXDR], s.[RXBAL], s.[RXANT], s.[ITCF], s.[VDLS], s.[MNDL], s.[MNUL], s.[FPHO],

s.[ISS], s.[PRE], s.[SBCNF], s.[SBCNH], s.[SBCN], s.[SBCNAF], s.[SBCNAH], s.[RXTA], s.[DEC], s.[IHTA], s.[TTRC],

s.[MTTR], s.[DHP], s.[DNP], s.[DLP], s.[UP1], s.[UP2], s.[UP3], s.[UP4], s.[SSW1], s.[SSW2], s.[SSW3], s.[ISW11],

s.[ISW12], s.[ISW13], s.[ISW21], s.[ISW22], s.[ISW23], s.[ISW31], s.[ISW32], s.[ISW33], s.[BGSW1], s.[BGSW2],

s.[BGSW3], s.[QCATR], s.[QCATN], s.[QCATQ], s.[QCATD], s.[UBL1], s.[UBL2], s.[UBL3], s.[UBL4], s.[UBL5], s.[UBL6],

s.[ABL1], s.[ABL2], s.[ABL3], s.[ABL4], s.[ABL5], s.[BL02], s.[BL03], s.[BL04], s.[BL12], s.[BL13], s.[BL14],

s.[BL23], s.[BL24], s.[RL02], s.[RL03], s.[RL04], s.[RL12], s.[RL13], s.[RL14], s.[RL23], s.[RL24], s.[EGIC],

s.[IEPH], s.[SPL]
FROM tblPerfectBsc AS f, tblAllBsc AS s
WHERE f.[BSC] <> s.[BSC] AND (f.[NPC] <> s.[NPC] OR f.[GMAC] <> s.[GMAC] OR f.[GMIC] <> s.[GMIC] OR f.[DMAC] <>

s.[DMAC] OR f.[DMIC] <> s.[DMIC] OR f.[DISB] <> s.[DISB] OR f.[TIM] <> s.[TIM] OR f.[EEF] <> s.[EEF] OR f.[EPF] <>

s.[EPF] OR f.[EOF] <> s.[EOF] OR f.[ERF] <> s.[ERF] OR f.[HRI] <> s.[HRI] OR f.[HRL] <> s.[HRL] OR f.[HRU] <>

s.[HRU] OR f.[AUT] <> s.[AUT] OR f.[ALT] <> s.[ALT] OR f.[AML] <> s.[AML] OR f.[ACH] <> s.[ACH] OR f.[IAC] <>

s.[IAC] OR f.[SAL] <> s.[SAL] OR f.[ASG] <> s.[ASG] OR f.[CSD] <> s.[CSD] OR f.[CSU] <> s.[CSU] OR f.[TGT] <>

s.[TGT] OR f.[HDL] <> s.[HDL] OR f.[HUL] <> s.[HUL] OR f.[CLR] <> s.[CLR] OR f.[CTR] <> s.[CTR] OR f.[CTC] <>

s.[CTC] OR f.[MINHTT] <> s.[MINHTT] OR f.[MAXHTT] <> s.[MAXHTT] OR f.[MAXHTS] <> s.[MAXHTS] OR f.[TCHFR] <>

s.[TCHFR] OR f.[SCHFR] <> s.[SCHFR] OR f.[CNGT] <> s.[CNGT] OR f.[CNGS] <> s.[CNGS] OR f.[CS] <> s.[CS] OR f.[CSR]

<> s.[CSR] OR f.[PRDMHT] <> s.[PRDMHT] OR f.[PRDMHS] <> s.[PRDMHS] OR f.[PRDCFR] <> s.[PRDCFR] OR f.[PRDCNG] <>

s.[PRDCNG] OR f.[HIFLVL] <> s.[HIFLVL] OR f.[HIFSHR] <> s.[HIFSHR] OR f.[PRDHIF] <> s.[PRDHIF] OR f.[PRDBNT] <>

s.[PRDBNT] OR f.[SMBNT] <> s.[SMBNT] OR f.[EMBNT] <> s.[EMBNT] OR f.[GTUGT] <> s.[GTUGT] OR f.[BCSUL] <> s.[BCSUL]

OR f.[LAPDL] <> s.[LAPDL] OR f.[MSSCF] <> s.[MSSCF] OR f.[MSSCS] <> s.[MSSCS] OR f.[ALFRT] <> s.[ALFRT] OR f.[ALHRT]

<> s.[ALHRT] OR f.[ALSDC] <> s.[ALSDC] OR f.[DINHO] <> s.[DINHO] OR f.[DEXDR] <> s.[DEXDR] OR f.[RXBAL] <> s.[RXBAL]

OR f.[RXANT] <> s.[RXANT] OR f.[ITCF] <> s.[ITCF] OR f.[VDLS] <> s.[VDLS] OR f.[MNDL] <> s.[MNDL] OR f.[MNUL] <>

s.[MNUL] OR f.[FPHO] <> s.[FPHO] OR f.[ISS] <> s.[ISS] OR f.[PRE] <> s.[PRE] OR f.[SBCNF] <> s.[SBCNF] OR f.[SBCNH]

<> s.[SBCNH] OR f.[SBCN] <> s.[SBCN] OR f.[SBCNAF] <> s.[SBCNAF] OR f.[SBCNAH] <> s.[SBCNAH] OR f.[RXTA] <> s.[RXTA]

OR f.[DEC] <> s.[DEC] OR f.[IHTA] <> s.[IHTA] OR f.[TTRC] <> s.[TTRC] OR f.[MTTR] <> s.[MTTR] OR f.[DHP] <> s.[DHP]

OR f.[DNP] <> s.[DNP] OR f.[DLP] <> s.[DLP] OR f.[UP1] <> s.[UP1] OR f.[UP2] <> s.[UP2] OR f.[UP3] <> s.[UP3] OR

f.[UP4] <> s.[UP4] OR f.[SSW1] <> s.[SSW1] OR f.[SSW2] <> s.[SSW2] OR f.[SSW3] <> s.[SSW3] OR f.[ISW11] <> s.[ISW11]

OR f.[ISW12] <> s.[ISW12] OR f.[ISW13] <> s.[ISW13] OR f.[ISW21] <> s.[ISW21] OR f.[ISW22] <> s.[ISW22] OR f.[ISW23]

<> s.[ISW23] OR f.[ISW31] <> s.[ISW31] OR f.[ISW32] <> s.[ISW32] OR f.[ISW33] <> s.[ISW33] OR f.[BGSW1] <> s.[BGSW1]

OR f.[BGSW2] <> s.[BGSW2] OR f.[BGSW3] <> s.[BGSW3] OR f.[QCATR] <> s.[QCATR] OR f.[QCATN] <> s.[QCATN] OR f.[QCATQ]

<> s.[QCATQ] OR f.[QCATD] <> s.[QCATD] OR f.[UBL1] <> s.[UBL1] OR f.[UBL2] <> s.[UBL2] OR f.[UBL3] <> s.[UBL3] OR

f.[UBL4] <> s.[UBL4] OR f.[UBL5] <> s.[UBL5] OR f.[UBL6] <> s.[UBL6] OR f.[ABL1] <> s.[ABL1] OR f.[ABL2] <> s.[ABL2]

OR f.[ABL3] <> s.[ABL3] OR f.[ABL4] <> s.[ABL4] OR f.[ABL5] <> s.[ABL5] OR f.[BL02] <> s.[BL02] OR f.[BL03] <>

s.[BL03] OR f.[BL04] <> s.[BL04] OR f.[BL12] <> s.[BL12] OR f.[BL13] <> s.[BL13] OR f.[BL14] <> s.[BL14] OR f.[BL23]

<> s.[BL23] OR f.[BL24] <> s.[BL24] OR f.[RL02] <> s.[RL02] OR f.[RL03] <> s.[RL03] OR f.[RL04] <> s.[RL04] OR

f.[RL12] <> s.[RL12] OR f.[RL13] <> s.[RL13] OR f.[RL14] <> s.[RL14] OR f.[RL23] <> s.[RL23] OR f.[RL24] <> s.[RL24]

OR f.[EGIC] <> s.[EGIC] OR f.[IEPH] <> s.[IEPH] OR f.[SPL] <> s.[SPL]);



please give me a solution quickly...

Thanks,
latha123laksh
Was This Post Helpful? 0
  • +
  • -

#5 itlee  Icon User is offline

  • D.I.C Head

Reputation: 7
  • View blog
  • Posts: 55
  • Joined: 16-July 08

Re: Expression too Complex

Posted 07 May 2009 - 04:43 AM

What are you trying to achieve? what data are you expecting from the query?

itlee.
Was This Post Helpful? 0
  • +
  • -

#6 papuccino1  Icon User is offline

  • His name was Robert Paulson.
  • member icon

Reputation: 63
  • View blog
  • Posts: 1,121
  • Joined: 02-March 08

Re: Expression too Complex

Posted 07 May 2009 - 05:20 AM

Oh Christ, it burns!
Was This Post Helpful? 0
  • +
  • -

#7 Bocard  Icon User is offline

  • D.I.C Head

Reputation: 15
  • View blog
  • Posts: 223
  • Joined: 24-September 08

Re: Expression too Complex

Posted 07 May 2009 - 11:35 AM

omg :| are you serious about this? :|:|
Was This Post Helpful? 0
  • +
  • -

#8 SixOfEleven  Icon User is offline

  • using Caffeine;
  • member icon

Reputation: 945
  • View blog
  • Posts: 6,342
  • Joined: 18-October 08

Re: Expression too Complex

Posted 07 May 2009 - 12:17 PM

Your names are not very descriptive for somebody else to read.

Can you post a screen shot of the table relations? Maybe a sample row from each table?
Was This Post Helpful? 0
  • +
  • -

#9 StarBP  Icon User is offline

  • New D.I.C Head

Reputation: 1
  • View blog
  • Posts: 42
  • Joined: 06-May 09

Re: Expression too Complex

Posted 07 May 2009 - 12:52 PM

I don't think this belongs in the C# forum.... Anyway, your code looks pretty badly organized. Also, that is a very complex query. Please set the "Question Type" to Advanced and post in a more appropriate forum.

I don't think this belongs in the C# forum.... Anyway, your code looks pretty badly organized. Also, that is a very complex query. Please set the "Question Type" to Advanced and post in a more appropriate forum.

I don't think this belongs in the C# forum.... Anyway, your code looks pretty badly organized. Also, that is a very complex query. Please set the "Question Type" to Advanced and post in a more appropriate forum.
Was This Post Helpful? 0
  • +
  • -

#10 Robin Marsh  Icon User is offline

  • New D.I.C Head

Reputation: 1
  • View blog
  • Posts: 13
  • Joined: 07-May 09

Re: Expression too Complex

Posted 07 May 2009 - 01:52 PM

Could you normalise the data to trim down the tables as there is an abundent amount of columns in each table.

Example:

It seems that you have multiple columns like '21DB', '24DB' and so on; could this not be a single column such as 'DB Values'.

Please clarify a single record from each table and their corresponding joins.

This post has been edited by Robin Marsh: 07 May 2009 - 01:54 PM

Was This Post Helpful? 0
  • +
  • -

Page 1 of 1