Re: [GENERAL] Problem with joining two tables

am Wed, dem 05.12.2007, um 14:42:32 +0100 mailte Przemyslaw Bojczuk folgendes:
> Hello!
>
> I have a problem joining two tables. I tried various types of join and
> none seems to work as I expect
>
> Table 1:
>
> id | stuff
> -----------
> 1 | sth1
> 2 | sth2
> 3 | sth3
> 4 | sth4
> 5 | sth5
> .. | ...
>
> Table 2:
>
> id | desc | etc
> ------------------
> 1 | desc1 | etc1
> 2 | desc2 | etc2
> 2 | desc3 | etc3
> 2 | desc4 | etc4
> 3 | desc5 | etc5
> | desc6 | etc6
> 5 | desc7 | etc7
> .. | ... | ...
>
> I need something like:
>
> id | stuff | desc | etc
> -------------------------
> 1 | sth1 | desc1 | etc1
> 2 | sth2 | desc2 | etc2
> 2 | sth2 | desc3 | etc3
> 2 | sth2 | desc4 | etc4
> 3 | sth3 | desc5 | etc5
> 5 | sth5 | desc7 | etc7
>

Okay, let's try:

first i create your tables like above:

test=*# select * from t1;
 id | stuff
----+-------

  1 | sth1
  2 | sth2
  3 | sth3
  4 | sth4
  5 | sth5

test=*# select * from t2;
 id | des | etc
----+-------+------

  1 | desc1 | etc1
  2 | desc2 | etc2
  2 | desc3 | etc3
  2 | desc4 | etc4
  3 | desc5 | etc5
    | desc6 | etc6
  5 | desc7 | etc7

And now:

test=*# select t1.id, t1.stuff, t2.des, t2.etc from t1, t2 where t1.id=t2.id;  id | stuff | des | etc
----+-------+-------+------

  1 | sth1  | desc1 | etc1
  2 | sth2  | desc2 | etc2
  2 | sth2  | desc3 | etc3
  2 | sth2  | desc4 | etc4
  3 | sth3  | desc5 | etc5
  5 | sth5  | desc7 | etc7

is this your expected result?

Do you need help?

In addition to our free technical library, Pantek provides professional IT services to companies who utilize Open Source software: Learn more about Pantek's Technical Support offerings Place an order for 24/7/365 Technical Support here Learn more about Pantek, who we are, and what we do Chat with a Live Operator Related postgresql.org Links pgsql-admin pgsql-advocacy pgsql-announce pgsql-bugs pgsql-cygwin pgsql-docs pgsql-general pgsql-interfaces pgsql-jdbc pgsql-jobs pgsql-novice pgsql-odbc pgsql-performance pgsql-php pgsql-ports pgsql-sql Request more information about Pantek

Andreas

-- 
Andreas Kretschmer
Kontakt:  Heynitz: 035242/47150,   D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID:   0x3FFF606C, privat 0x7F4584DA   
http://wwwkeys.de.pgp.net

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

               
http://www.postgresql.org/docs/faq