Richard Huxton said:
> Ferruccio Zamuner wrote:
>> Hi,
>>
>> I've following select, and I expect to receive a single record as result
>> from it:
>>
>> select c.id
>> from copie as c
>> where c.enum=46857 and
>> c.condizio_prestito = 'A' and
>> c.id not in (select id_copia from testi
Ferruccio Zamuner wrote:
Hi,
I've following select, and I expect to receive a single record as result
from it:
select c.id
from copie as c
where c.enum=46857 and
c.condizio_prestito = 'A' and
c.id not in (select id_copia from testi_fermi_prenotati) and
c.id not in (select id_co
Hi,
I've following select, and I expect to receive a single record as result from it:
select c.id
from copie as c
where c.enum=46857 and
c.condizio_prestito = 'A' and
c.id not in (select id_copia from testi_fermi_prenotati) and
c.id not in (select id_copia from prestiti);
