Re: [GENERAL] Problem with joining two tables

2007-12-05 Thread Przemyslaw Bojczuk
Thomas Burdairon wrote: > hope this help. Thank you, it helped a lot! It was a part of a bigger problem (involving PostGIS, Mapserver et al.) and I *thought* I traced it down to this join, but now it's clear the problem lies completely elsewhere. Thanks again! PB -- Geographical Information Sys

Re: [GENERAL] Problem with joining two tables

2007-12-05 Thread A. Kretschmer
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 >

Re: [GENERAL] Problem with joining two tables

2007-12-05 Thread Thomas Burdairon
On 5 déc. 07, at 14:42, Przemyslaw Bojczuk wrote: 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 ---

[GENERAL] Problem with joining two tables

2007-12-05 Thread Przemyslaw Bojczuk
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