Link Table

[rekhatr10]

Hi everyone

cr 7.0
sql 2000

Order(t1) Billed(t2)
orderdate XacDate
Account account
cpt cpt
osdesc procdesc
prov prov
rdoc rdoc
status
dept
I am doing a left outer join on orderdate and account number. I just want to display the records which does not have a matching records in billed(t2) table. Just want to display unbilled records. Any suggestions will be helpful.

Thank you

Rekha

 

[Katy44]

If order is joined to Billed with a left outer join on Order.Account = Billed.Account,
all you should need to do is say
where isNull(Billed.account)
in the selection criteria

 

[rekhatr10]

Katy44


Thank you.

Rekha