X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.193]) by svr1.postgresql.org (Postfix) with ESMTP id 4C32F30DE85 for ; Tue, 17 Jun 2003 18:36:02 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (svr1.postgresql.org [64.117.224.193]) (amavisd-new, port 10024) with ESMTP id 68924-05 for ; Tue, 17 Jun 2003 15:35:51 -0300 (ADT) Received: from mail.virginia.edu (mail.Virginia.EDU [128.143.2.9]) by svr1.postgresql.org (Postfix) with SMTP id 2C3C530D1CE for ; Tue, 17 Jun 2003 15:35:51 -0300 (ADT) Received: from smtp.mail.virginia.edu by mail.virginia.edu id aa01381; 17 Jun 2003 14:35 EDT Received: from virginia.edu (d-128-19-222.bootp.Virginia.EDU [128.143.19.222]) by smtp.mail.Virginia.EDU (8.11.7/8.11.6) with ESMTP id h5HIZll36340 for ; Tue, 17 Jun 2003 14:35:47 -0400 Message-ID: <3EEF6170.1040905@virginia.edu> Date: Tue, 17 Jun 2003 14:44:00 -0400 From: Jodi Kanter User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:0.9.4) Gecko/20011128 Netscape6/6.2.1 X-Accept-Language: en-us MIME-Version: 1.0 To: Postgres SQL List Subject: join syntax Content-Type: multipart/alternative; boundary="------------000201000809020603080201" X-Archive-Number: 200306/198 X-Sequence-Number: 13956 --------------000201000809020603080201 Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit One of my colleagues has created a database where he has the same field name in two tables and uses this field to link his tables rather than some arbitrary value. For example, he has used "exp_id" in two tables. When writing his joins he uses a syntax that says something like JOIN ON EXP_ID. Can someone tell me what that syntax should be? I am not very familiar with it since I typically use the syntax where one field is set equal to the other. Personally I prefer not to set databases up this way but cannot seem to convince him of this. And yet I am supposed to now help him with his database and application.. Is there some documentation that would define this type of syntax? How is this handled if you have more than one table in the join? It does not appear that this format would allow for this. Thanks Jodi -- _______________________________ Jodi L Kanter BioInformatics Database Administrator University of Virginia (434) 924-2846 jkanter@virginia.edu --------------000201000809020603080201 Content-Type: text/html; charset=us-ascii Content-Transfer-Encoding: 7bit One of my colleagues has created a database where he has the same field name in two tables and uses this field to link his tables rather than some arbitrary value. For example, he has used "exp_id" in two tables. When writing his joins he uses a syntax that says something like JOIN ON EXP_ID. Can someone tell me what that syntax should be? I am not very familiar with it since I typically use the syntax where one field is set equal to the other.
Personally I prefer not to set databases up this way but cannot seem to convince him of this. And yet I am supposed to now help him with his database and application.. Is there some documentation that would define this type of syntax? How is this handled if you have more than one table in the join? It does not appear that this format would allow for this.
Thanks
Jodi
--
________________________________

_______________________________
Jodi L Kanter
BioInformatics Database Administrator
University of Virginia
(434) 924-2846
jkanter@virginia.edu

 

 

 

--------------000201000809020603080201--