From: phil@Stimpy.netroedge.com
To: Pablo Salazar <ssalazar@goliat.espol.edu.ec>
Cc: pgsql-interfaces@postgreSQL.org
Subject: Re: Foreing Key in Postgres ????
Date: Mon, 24 Jul 2000 15:13:54 -0700
Message-ID: <20000724151354.P9654@Stimpy.netroedge.com> (raw)
In-Reply-To: <397CB9EB.7FEE6B84@goliat.espol.edu.ec>
References: <397CB9EB.7FEE6B84@goliat.espol.edu.ec>
I think this might be a little out of place (wrong list?), but here's
a quick answer:
select tableone.name,tabletwo.title where
tableone.index=tabletwo.index order by tableone.name asc;
That's a simple relational selection for two tables which might look
like:
tableone:
name text
index int4
tabletwo:
title text
index int4
Good luck!
Phil
On Mon, Jul 24, 2000 at 04:49:31PM -0500, Pablo Salazar wrote:
> Hellos Folks!!
>
> Someane , know be do relations between tables (FK)
>
> please Help me
> thanks
>
> Pablo
Content-Description: Card for Pablo Salazar
--
Philip Edelbrock -- IS Manager -- Edge Design, Corvallis, OR
phil@netroedge.com -- http://www.netroedge.com/~phil
PGP F16: 01 D2 FD 01 B5 46 F4 F0 3A 8B 9D 7E 14 7F FB 7A
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: phil@Stimpy.netroedge.com, ssalazar@goliat.espol.edu.ec
Subject: Re: Foreing Key in Postgres ????
In-Reply-To: <20000724151354.P9654@Stimpy.netroedge.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox