ok. my conscience got the best of me. maybe for worse though. :)
This to me is like giving you a rope and a stool and i don't think it'll
That said consider something like this:
when z.sys_buscd_item_desc1 is null then
a.sys_type_cd, -- join key
a.age, -- where clause
join TABLE2 c on isnull(a.age,'00')=c.sys_item
RIGHT OUTER join TABLE1 a on (z.sys_z.sys_item = coalesece(a.age,'00') )
i switched your ON clause and WHERE clause so be sure to take that under
consideration. And finally its not tested.
Best of luck.
On Tue, Mar 4, 2014 at 7:49 AM, Stephen Sprague <[EMAIL PROTECTED]> wrote: