I didn't receive the announcement. 

Best regards, Randy

Hi, Ken:

Thanks!  I resolved the issue by changing the RIGHT OUTER JOIN to a LEFT OUTER JOIN, I'll make a note that the position of the * relative to the =...

This gives the correct result, thanks!

I used Microsoft's sample code to come up with the new syntax:

[START CODE SAMPLE]

This query uses an old-style outer join operator.

USE pubs

SELECT employee.job_id, employee.emp_id,

   employee.fname,...

No, I'm running in Compatibility Level 80 for both queries.  I'll set the level to 90 and run the modified query and post the results later today.  (I'm working on another...