Path: csiph.com!usenet.pasdenom.info!weretis.net!feeder1.news.weretis.net!news.solani.org!.POSTED!not-for-mail From: Mladen Gogala Newsgroups: comp.databases.postgresql Subject: Re: Joining two tables using *two* columns (instead of one) Date: Fri, 6 Apr 2012 04:44:10 +0000 (UTC) Organization: solani.org Lines: 12 Message-ID: References: <4f7d9c45$0$1745$426a34cc@news.free.fr> <4f7dc1f1$0$21932$426a74cc@news.free.fr> <9u6gdcF6d7U1@mid.individual.net> Mime-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit X-Trace: solani.org 1333687450 24552 eJwFwYEBwDAEBMCVKF6Mk+L3HyF3YVB0OgIeDH4rPjghFydddOu/lYpK6902aQ6zQGIssA8PQREc (6 Apr 2012 04:44:10 GMT) X-Complaints-To: abuse@news.solani.org NNTP-Posting-Date: Fri, 6 Apr 2012 04:44:10 +0000 (UTC) User-Agent: Pan/0.135 (Tomorrow I'll Wake Up and Scald Myself with Tea; GIT 30dc37b master) X-User-ID: eJwNyMEBwEAEBMCWBIuUw7ntv4RkngOLJ056IBwEq0dUeZFNXcRL25tnKTL/qJWd9VYUbXL7Ay+mEek= Cancel-Lock: sha1:v7u6gnrWY0U2OUshIHJNaB/ZBcE= X-NNTP-Posting-Host: eJwFwYEBwCAIA7CXQGmRcyqO/09Ygk1nZxAMDKYMoI4ECy6/+t6Ka3OsfWr0bKPbj7IiufUDFc4Q8g== Xref: csiph.com comp.databases.postgresql:338 On Fri, 06 Apr 2012 04:12:03 +0000, Jasen Betts wrote: > the syntax is correct. I don't think it is the correct syntax for join on two columns. I have shown an example of join on two columns. Syntax maybe correct, but I am not so sure about the logical equivalence. -- http://mgogala.byethost5.com