Two tables returning only one result

Question

select
        cliente.codcliente,
        cliente.dt_cadastro
from cliente
where cliente.codcliente in ('00000224', '00000170', '00061825', '01009838')
order by cliente.codcliente

select  nfsaidc.codcliente,
        nfsaidc.numnf,
        nfsaidc.dt_emissao,
        nfsaidc.totalnf
from nfsaidc
where NFSAIDC.CODCLIENTE in ('00000224', '00000170', '00061825', '01009838') 
order by nfsaidc.numnf

Guys, I need to retouch only one row of each client with CODCLIENTE, DT_CADASTRO, NUMNF, DT_EMISSAO, TOTALNF columns. The result would be the date the customer was registered with the first purchase made. The result I need would be the image below:

I am using IBEXPERT with Firebird 2.1 but accept suggestions from other platforms.

Answer 1

Charles, I can’t simulate it here, but the concept (SQL) is this:

SELECT CL.codcliente, CL.dt_cadastro, NF.numnf, MIN(NF.dt_emissao), NF.totalnf
FROM nfsaidc NF
LEFT OUTER JOIN cliente CL ON CL.codcliente = NF.codcliente
GROUP BY CL.codcliente
ORDER BY CL.codcliente