Concatenate multiple records to one record with postgresql

Question

I have a query like this:

Select * from
  (Select a, b, c from table1 where some condition) as Result1,
  (Select d, e from table2 where some another condition) as Result2

everything is OK until one of the nested selects returns nothing, then another select returns nothing too in finally select.

please tell me what is wrong with me?

replace your select statement with coalesce or is null function that will prevent you from throwing null value error — Ankit Agrawal
– Ankit Agrawal, Commented Sep 25, 2017 at 7:31
Please Edit your question and add some sample data and the expected output based on that data. Formatted text please, no screen shots. edit your question - do not post code or additional information in comments. — user330315
– user330315, Commented Sep 25, 2017 at 7:35
@AnkitAgrawal thanks for your comment, possible give me a sample, i'm new in posgresql, i did this with join in mysql — Fatemeh Gharri
– Fatemeh Gharri, Commented Sep 25, 2017 at 7:35
Use a full outer join between your two resultsets, rather than a Cartesian product. — Phylogenesis
– Phylogenesis, Commented Sep 25, 2017 at 7:35
@Phylogenesis i did this but it doesn't work first because i didn't know that ON condition join in postgresql is forced. finally it's working with this: Select * from (Select a, b, c from table1 where some condition) as Result1 FULL OUTER JOIN (Select d, e from table2 where some another condition) as Result2 ON 1 = 1 — Fatemeh Gharri
– Fatemeh Gharri, Commented Sep 25, 2017 at 7:44

Phylogenesis · Accepted Answer · 2017-09-25 07:41:29Z

1

As per my comment above, the following should work how you expect:

select
    *
from
    (select a, b, c from table1 where predicate1) Result1
full outer join
    (select d, e from table2 where predicate2) Result2 on
        1 = 1

answered Sep 25, 2017 at 7:41

Phylogenesis

7,90024 silver badges27 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Fatemeh Gharri Over a year ago

that's exactly i did! Thanks

being_felicity · Accepted Answer · 2017-09-25 07:41:23Z

0

Try:

Select (
  (Select a, b, c from table1 where some condition) as Result1,
  (Select d, e from table2 where some another condition) as Result
)

Try an inner or self join
Post some result samples to get a better understanding of the issue.

edited Sep 25, 2017 at 7:41

user330315

answered Sep 25, 2017 at 7:39

being_felicity

891 silver badge8 bronze badges

Collectives™ on Stack Overflow

Concatenate multiple records to one record with postgresql

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related