Script calculation issue

[#1]

table1:

  customerid ,bookingloc, deliverloc

  100                1                  2

table2:

  locid     locname

  1          bangalore

  2           chennai

how i can achieve below output as w/o null records

  customerid  bookingloc  deliveryloc

  100              bangalore     chennai

[MarcoWedel]

Hi,

one front end solution without changing your data model could be:

hope this helps

regards

Marco