Subject Re[5]: [ib-support] Strange query problem
Author Javier Casro
Alexander Tabakov <saho@...> escribió en el mensaje de noticias

> Well I know this, but just can't thinkn of anything more simple.
> I must exclude all of the rows in tbl_invalid.
> Any sugestions?

How about

"select pty.party_id, bill.due_date, bill.service_tax
tbl_party pty
join tbl_bill bill on (bill.account_id = pty.account_id) and
bill.service_id = 1
left join tbl_invalid inv on (inv.party_id=pty.party_id)
where bill.service=1 and is null"

I have not tested it, though.


Javier Castro