I am not sure if I understand what you're trying to achieve.
It would help if you could provide an output example.
Best,
Oliver
Sent via iPhone, apologies for any errors
Hi,
I am having the following question. I am not sure how to approach it. Please help!
table A
| name | col1 | col2 | col3 | col4 |
| apple | 100 | 11111 | 1 | APL |
| orange | 200 | 22222 | 3 | ORG |
| carrot | 300 | 33333 | 3 | CRT |
table B
| custom_name | value | obj_type | obj_id |
| apple | a | FR | 100 |
| orange | o | FR | 200 |
| carrot | c | VG | 300 |
| apple | d | FR | 11111 |
| orange | e | VG | 22222 |
| carrot | f | UC | 33333 |
| apple | h | VG | 1 |
| orange | o | FR | 3 |
| carrot | c | VG | 3 |
when obj_type ='FR' then join on col1
When obj_type='VG' then join on col2
When obj_type='UC' then join on col2
Thanks In advance,
CB