From: | Angelo CONFLITTI <mvca(at)yahoo(dot)com> |
---|---|
To: | pgsql-sql(at)postgresql(dot)org |
Subject: | Problems with OUTER JOIN - UNION ..... |
Date: | 1999-03-17 13:34:12 |
Message-ID: | 19990317133412.15547.rocketmail@send104.yahoomail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
hi,
I have some problems with the OUTER JOIN.
I have 2 tables:
The first TABELLA1:
NAME | COD
------------+-----
PIPPO |1AA
PLUTO |2AB
TOPOLINO |3AC
PAPERINO |7BB
PAPERONE |CC2
the second TABELLA2:
COD | COUNTRY
----+-------------
1AA |ITALY
2AB |GERMANY
CC2 |SWEDEN
I want this query result:
NAME | COD | COUNTRY
------------+------+--------------
PIPPO |1AA |ITALY
PLUTO |2AB |GERMANY
TOPOLINO |3AC |
PAPERINO |7BB |
PAPERONE |CC2 |SWEDEN
I tried some queries but with bad results!
The command OUTER JOIN (or equivalent) isn't in PostgreSQL (It's true?).
One of my tries is:
-------------------------------
SELECT a.name, a.cod, b.country
FROM tabella1 a, tabella2 b
WHERE a.cod = b.cod
UNION
SELECT a.name, a.cod, ''
FROM tabella1 a;
-------------------------------
but I have an error with the program "psql":
"pqReadData() -- backend closed the channel unexpectedly. ......."
and the psql terminate his execution.
The query of example is right?
There is another way?
If I have 3 tables can I use more UNION?
If I want an order by a column where can I write the "ORDER BY" command?
(the last) with the UNION, I think, I'll have more equal rows: where I
can write the "GROUP BY" command?
Excuse for my english language and thank for any
help.
Angelo CONFLITTI.
_________________________________________________________
DO YOU YAHOO!?
Get your free @yahoo.com address at http://mail.yahoo.com
From | Date | Subject | |
---|---|---|---|
Next Message | Angelo CONFLITTI | 1999-03-17 13:45:41 | Problems with OUTER JOIN - UNION ...... |
Previous Message | Herouth Maoz | 1999-03-17 09:58:46 | Re: [SQL] How match percent sign in SELECT using LIKE? |