Received: from Stimpy.netroedge.com (IDENT:phil@Stimpy.netroedge.com [206.58.104.66]) by hub.org (8.10.1/8.10.1) with ESMTP id e6OMB3h51446 for ; Mon, 24 Jul 2000 18:11:03 -0400 (EDT) Received: (from phil@localhost) by Stimpy.netroedge.com (8.9.1a/8.9.1) id PAA15797; Mon, 24 Jul 2000 15:13:54 -0700 Date: Mon, 24 Jul 2000 15:13:54 -0700 From: phil@Stimpy.netroedge.com To: Pablo Salazar Cc: pgsql-interfaces@postgreSQL.org Subject: Re: Foreing Key in Postgres ???? Message-ID: <20000724151354.P9654@Stimpy.netroedge.com> References: <397CB9EB.7FEE6B84@goliat.espol.edu.ec> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.2.4i In-Reply-To: <397CB9EB.7FEE6B84@goliat.espol.edu.ec>; from ssalazar@goliat.espol.edu.ec on Mon, Jul 24, 2000 at 04:49:31PM -0500 X-Archive-Number: 200007/178 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