Subquery?

  • Thread starter Thread starter Doreen
  • Start date Start date
D

Doreen

I need to get the value from another table if the field in
the current is null.

What would be the most efficient or easiest way to do this?

tblsched.payrate = null get payrate from tblrate.payrate

any help would be most appreciated
 
Something along the lines of
SELECT Nz(tblsched.payrate, tblrate.payrate)
FROM etc

Hope This Helps
Gerald Stanley MCSD
 
Back
Top