Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM SQL » View Thread |
Messages 1 to 3 of 3 total |
Except in SQL |
Thu, Apr 2 2009 4:40 AM | Permanent Link |
Hiba Hable | Hello,
i am trying to execute the follwing sql statment but i am getting an error, i need to know how to write "except" in dbisam. (select cnr,bl from histcnr where act='BOOK' union select cnr,bl from histcnr where (act='DCMT' and pod='LBBEY') union select cnr,bl from histcnr where act='RMTY') except (select cnr,bl from histcnr where act='DMEX' union select cnr,bl from histcnr where act='LDMT' or act='LDFL') Thanks Hiba |
Thu, Apr 2 2009 5:16 AM | Permanent Link |
"John Hay" | Hiba
> i am trying to execute the follwing sql statment but i am getting an error, i need to know how to write "except" in dbisam. > > (select cnr,bl from histcnr where act='BOOK' union > select cnr,bl from histcnr where (act='DCMT' and pod='LBBEY') union > select cnr,bl from histcnr where act='RMTY') > except > (select cnr,bl from histcnr where act='DMEX' union > select cnr,bl from histcnr where act='LDMT' or act='LDFL') DBIsam does not support derived tables. In this particular case does the following produce the correct result? select cnr,bl from histcnr where act='BOOK' union select cnr,bl from histcnr where (act='DCMT' and pod='LBBEY') union select cnr,bl from histcnr where act='RMTY' except select cnr,bl from histcnr where act='DMEX' union or act='LDMT' or act='LDFL' John |
Thu, Apr 2 2009 6:19 AM | Permanent Link |
Fernando Dias Team Elevate | Hiba,
The correct sintax to do what you want is: select cnr,bl from histcnr where act='BOOK' union select cnr,bl from histcnr where act='DCMT' and pod='LBBEY' union select cnr,bl from histcnr where act='RMTY' except select cnr,bl from histcnr where act='DMEX' except select cnr,bl from histcnr where act='LDMT' or act='LDFL' -- Fernando Dias [Team Elevate] |
This web page was last updated on Tuesday, May 7, 2024 at 06:25 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |