Re: Re: Minus set operator

Posted in 2008

CEDRIC CHIU — Fri, 30 May 2008 04:06:03 — source: IIUG Forums & Mailing Lists

I kinda encouter syntax error. > SELECT msisdn FROM A NOT EXISTS ( SELECT msisdn FROM B where a.msisdn =b.msisdn ); 201: A syntax error has occurred. Error in line 1Near character position 28 Please advise

↪ replying to CEDRIC CHIU

Vivian Jones — Fri, 30 May 2008 04:20:05 — source: IIUG Forums & Mailing Lists

You forgot the WHERE clause. Vivian Jones President IBM Information Management Awards 2006 - Most Distinguished Achievement Winner - Latin America Movil Colombia: (57-310) 4883890 Oficina Bogotá: (57-1) 3215753 Oficina Caracas: (58-212) 9056436 Email: jones@itconsultings.net Bogota, Medellin, Cali - Colombia Caracas - Venezuela Web Site: www.itconsultings.net IBM Premier Business Partner Informix & DB2 Specialists Business Intelligence Solutions DataStage & QualityStage Specialists -----Mensaje original----- De: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] En nombre de CEDRIC CHIU Enviado el: jueves, 29 de mayo de 2008 23:06 Para: ids@iiug.org Asunto: Re: Re: Minus set operator [12247] I kinda encouter syntax error. > SELECT msisdn FROM A NOT EXISTS ( SELECT msisdn FROM B where a.msisdn =b.msisdn ); 201: A syntax error has occurred. Error in line 1Near character position 28 Please advise **************************************************************************** *** Forum Note: Use "Reply" to post a response in the discussion forum.

↪ replying to CEDRIC CHIU

Art Kagel — Fri, 30 May 2008 10:57:29 — source: IIUG Forums & Mailing Lists

SELECT msisdn FROM A WHERE NOT EXISTS ( SELECT msisdn FROM B where a.msisdn =b.msisdn ); On Fri, May 30, 2008 at 12:06 AM, CEDRIC CHIU <cedric.mh@gmail.com> wrote: > I kinda encouter syntax error. > > > SELECT msisdn FROM A NOT EXISTS ( SELECT msisdn FROM B where a.msisdn => b.msisdn ); > > 201: A syntax error has occurred. > Error in line 1> Near character position 28 > > Please advise > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > -- Art S. Kagel Oninit (www.oninit.com) IIUG Board of Directors (art@iiug.org) Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Oninit, the IIUG, nor any other organization with which I am associated either explicitely or implicitely. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves.