JOIN columns with no data

From: "Keith Worthington" <keithw(at)narrowpathinc(dot)com>
To: "PostgreSQL Novice" <pgsql-novice(at)postgresql(dot)org>
Subject: JOIN columns with no data
Date: 2004-12-21 21:13:31
Message-ID: 20041221211331.M54492@narrowpathinc.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hi All,

I am trying to create a fairly large join (7 tables) that needs to allow NULL
in columns.

Table 1
1 | A | 2
2 | B | 3

JOINed with

Table 2
1 | note

should output
1 | A | 2 | note
2 | B | 3 |

Kind Regards,
Keith

______________________________________________
99main Internet Services http://www.99main.com

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message George Weaver 2004-12-21 21:23:36 Re: JOIN columns with no data
Previous Message Vishal Kashyap @ [SaiHertz] 2004-12-21 18:41:46 Re: SQUID Log in PostgreSQL