Updating a record in a table in script - new to QlikView

[#1]

Hi

I am new to QlikView and also new to SQL.

I have the following code which updates the 'debtor' table:

Inner join(debtor)

LOAD "s-order",

    upper ("sorder-category") as "sorder-category";

SQL SELECT "s-order",

    "sorder-category"

FROM PUB.sorder;

How do I now update one of the other fields in the 'debtor' table based on the results from this code above?

Thanks

[#2]

what do You mean "update one of the other fields in the 'debtor' table based on the results from this code above"

You can

drop field 'fieldname' from 'other table'

Inner join(debtor)

LOAD "s-order",

    upper ("sorder-category") as "sorder-category",

fieldname;

SQL SELECT "s-order",

    "sorder-category",

fieldname

FROM PUB.sorder;

[#3]

Hi

The other field is called SKU (product code). I want to change the contents in SKU field based on the sorder-category field.

eg - If ("sorder-category"="PRO", "Project", "SKU")

Can I just write this query after the last line in the code above?

Thanks for your help

Mark