Re: Reg: Sql Join

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

Em 30/07/2014, às 11:08 PM, CrashBandi <crashbandicootu(at)gmail(dot)com> escreveu:

> 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
>