Re: [GENERAL] HELP with a Query

On Sat, Feb 21, 2004 at 05:20:51PM +0900, Alex wrote: > Hi, > I need some help with a query. > I use a reference table to lookup some codes. Everything works well if the > reference table contains a reference but the query fails if no reference > fails (Z.ref_code=123456). What I need to is eithe

[GENERAL] HELP with a Query

Hi, I need some help with a query. I use a reference table to lookup some codes. Everything works well if the reference table contains a reference but the query fails if no reference fails (Z.ref_code=123456). What I need to is either return 0 or null into Z.prim_exch if no reference can be found.