This is annoying me. Been working on some other things and this
complex query came back to bite me. Oracle 9i.

I have a parent record and one or more child records.

I want the query to join on the "Approved" record, (Status = 'A') where
it exists and if it doesn' exist then join on the draft record (Status
= 'D'). There is always one draft record, but there might be an
approved record.

I tried some attempts with subselects and NVLs, but they failed. I
didn't save this code.

Can anyone point me to Ask Tom or another example? I looked there
first, but I'm using the wrong keywords.

thanks,

Don