Hi guys !
I am a newbie on the forum so please pardon any mistakes..
I am looking for a case function that will allow me to do this;
Field_Item Field_Warehouse Field_code New_Field
123 11 null 999
123 12 999 999
321 11 998 998
321 12 998 998
So what I need is to have the Field_code of warehouse 12 in the New_Field.
A function that would look a little like this:
case when Field_code = 'null' then select Field_code with in Field_warehouse '12' end
I tried and tried but can't come up with it :(
Anyone an a brillant idea ??
Thanks guy !!!
A CASE allows for manipulating data within the same row. You can define a second query that fetches field_item and field_code for warehouse 12 and join this with the original query.
Use the result query to substitute null values with the field_code brought in from the 2nd query..