Re: Reg: Sql Join
От
Oliver d'Azevedo Christina
Тема
Re: Reg: Sql Join
Дата
Msg-id
1D742D88-394D-4B9D-ADF8-D0C832A5B16D@gmail.com
Ответ на
Reg: Sql Join (CrashBandi)
Список
Дерево обсуждения
Reg: Sql Join CrashBandi <crashbandicootu@gmail.com>
Re: Reg: Sql Join David G Johnston <david.g.johnston@gmail.com>
Re: Reg: Sql Join David G Johnston <david.g.johnston@gmail.com>
Re: Reg: Sql Join Oliver d'Azevedo Christina <oliveiros.cristina@gmail.com>
Re: Reg: Sql Join Gavin Flower <GavinFlower@archidevsys.co.nz>
Re: Reg: Sql Join Gavin Flower <GavinFlower@archidevsys.co.nz>
Re: Reg: Sql Join CrashBandi <crashbandicootu@gmail.com>
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 col1When obj_type='VG' then join on col2When obj_type='UC' then join on col2Thanks In advance,CB
В списке pgsql-sql по дате отправления
