Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM SQL » View Thread |
Messages 1 to 3 of 3 total |
Populating an empty column |
Thu, Apr 9 2015 9:52 AM | Permanent Link |
Boss | Hi I'm trying to union two queries but one has 2 columns and the other has 1. I want to populate the short query with a column matching name and filled with nulls
Query with 4 columns select a, b, from alphabet query with 3 columns select a, null as b from alphabet |
Thu, Apr 9 2015 10:00 AM | Permanent Link |
Boss | null as b is not the correct syntax to do this.
|
Thu, Apr 9 2015 10:08 AM | Permanent Link |
Raul Team Elevate | On 4/9/2015 9:52 AM, Boss wrote:
> Hi I'm trying to union two queries but one has 2 columns and the other has 1. I want to populate the short query with a column matching name and filled with nulls > select a, null as b from alphabet DBISAM does not like "null as b" (it would work for things like string though '' as c). I would use something like as a workaround : select a,NULLIF(a,a) as C from mytable Raul |
This web page was last updated on Monday, May 6, 2024 at 03:23 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |