> On Fri, Dec 05, 2003 at 13:20:27 -0500,
> Bob Powell <[EMAIL PROTECTED]> wrote:
>
> > SELECT * FROM addresses LEFT OUTER JOIN contacts ON
> > contacts.participant_id = addresses.participant_id;
> >
> > Running the select obviously works fine, it's just when I try to create a
> > table when I
On Fri, Dec 05, 2003 at 13:20:27 -0500,
Bob Powell <[EMAIL PROTECTED]> wrote:
> To whom it may concern,
>
> The following select works fine until I use the CREATE TEMP TABLE AS command because
> of the matching participant_id's in each table.
>
> SELECT * FROM addresses LEFT OUTER JOIN contac
To whom it may concern,
The following select works fine until I use the CREATE TEMP TABLE AS command because
of the matching participant_id's in each table.
SELECT * FROM addresses LEFT OUTER JOIN contacts ON
contacts.participant_id = addresses.participant_id;
Running the select obviously work
