ab initio - Iterating for each distrinct value of field in netezza

Question

There are 2 tables a and b. A has only 1 field acc and b has acc, names, city,ban and other fields.

I have to select a distinct acc from table a. If acc is x then I have to select name from table b else name and city from table b where a.acc=b.acc or a.acc=b.ban.

How to write for this in netezza

Answer 1

等待大神答复