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 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
