Alexander Tabakov <saho@...> escribió en el mensaje de noticias
131364406500.20030212175054@......

>
> 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
from
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 inv.party is null"

I have not tested it, though.

Regards,

Javier Castro