Hi,
same no, but similar yes
select decode(1, 0, 'deleted', 1, 'active', 2, ‘inserted’, null) from
RDB$DATABASE
regards,
Karol Bieniaszewski
From: zilez2...@yahoo.com [firebird-support]
Sent: Friday, November 24, 2017 3:12 PM
To: firebird-support@yahoogroups.com
Subject: [firebird-support] Al
As the tithe says, is there anything similar to MySQL ELT() function in
Firebird ?
Regards,
Zoran
24.11.2017 11:22, alauren...@gmail.com [firebird-support] wrote:
> Because of that matter, I manufacture that query :)
Remove TEMPSUB from FROM clause.
--
WBR, SD.
+++
Maybe I wasn't very clear
I have 2 tables
- SUBANS with fields CODSUB and DENSUB
- TEMPSUB with fields CODSBB and CANT
- Records in CODSUB and CODSBB are the same
I want to retrieve all the SUBANS records for which SUBANS.CODSUB is not EQUAL
with TEMPSUB CODSBB.
Because of that matte
Multumesc!
24.11.2017 8:53, alauren...@gmail.com [firebird-support] wrote:
> I have a query with no results and I doo't understand what I do wrong:
Conditions in your query will never met: you are asking for record that ARE
in tempsub
and at the same time ARE NOT in tempsub.
--
WBR, SD.
On 2017-11-24 09:53, alauren...@gmail.com [firebird-support] wrote:
> Hi!
>
> I have a query with no results and I doo't understand what I do wrong:
>
> SELECT DENSUB, CODSUB from SUBANS,TEMPSUB
>
> WHERE SUBANS.CODSUB=TEMPSUB.CODSBB AND SUBANS.CODSUB NOT IN (SELECT CODSBB
> FROM TEMPSUB) A
24.11.2017 10:53, alauren...@gmail.com wrote:
>
> I have a query with no results and I doo't understand what I do wrong:
>
> SELECT DENSUB, CODSUB from SUBANS,TEMPSUB
>
> WHERE SUBANS.CODSUB=TEMPSUB.CODSBB AND SUBANS.CODSUB NOT IN (SELECT
> CODSBB FROM TEMPSUB) AND SUBANS.CODPF='FL1' order by S