Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- select
- id,
- a.price as price_1701,
- b.price as price_1702,
- c.price as price_1703
- from
- t_1701 as a
- full join t_1702 as b using (id)
- full join t_1703 as c using (id)
- order by
- id ;
- select
- id,
- a.price as price_1701,
- b.price as price_1702,
- c.price as price_1703
- from
- ( select id from t_1701
- union
- select id from t_1702
- union
- select id from t_1703
- ) as t
- left join t_1701 as a using (id)
- left join t_1702 as b using (id)
- left join t_1703 as c using (id)
- order by
- id ;
Add Comment
Please, Sign In to add comment