Re: [SQL] Complex outer joins?

2003-03-27 Thread Correia, Carla
Hi... Postgres 7.3 I'm using the copy command to fill my tables. I've got this file with the data with delimiter '\t' and 'isnull' for nulls as follows: copy mytable FROM '/usr/share/postgresql/data1/skripte/Daten/mytable' using delimiters '\t' with null as 'isnull'; But I receive an

Re: [SQL] Complex outer joins?

2003-03-24 Thread Correia, Carla
:[EMAIL PROTECTED] Gesendet: Monday, March 24, 2003 11:44 AM Cc: '[EMAIL PROTECTED]' Betreff: Re: [SQL] Complex outer joins? On Mon, 24 Mar 2003, Correia, Carla wrote: > > Hi, > > I've got PsotgreSQL 7.3. > > My problem is joins. I've seen the syntax on joins

[SQL] Complex outer joins?

2003-03-24 Thread Correia, Carla
Password: d5B9Av Hi, I've got PsotgreSQL 7.3. My problem is joins. I've seen the syntax on joins and have sucessefully used SQLs with joins, but I've got some other big SQL statements using many and complex joins. Simplified example: select G.SELID, G.TEXT, L.ID as SELLEVELID ,

[SQL] Complex outer joins?

2003-03-24 Thread Correia, Carla
Hi, I've got PsotgreSQL 7.3. My problem is joins. I've seen the syntax on joins and have sucessefully used SQLs with joins, but I've got some other big SQL statements using many and complex joins. Simplified example: select G.SELID, G.TEXT, L.ID as SELLEVELID , L.SELLEVEL, L.LEVEL