Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Pgsql Novice > Need help with ...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 4 Topic 3101 of 3177
Post > Topic >>

Need help with INNER Join

by magawake@[EMAIL PROTECTED] ("Mag Gam") May 4, 2008 at 10:40 AM

------=_Part_13697_8905503.1209912005920
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Hello

When I needed to join tables I always used the equal syntax (ie. SELECT id
from foo,fee where id.foo=id.fee)

To my understanding, it is preferred to use the INNER JOIN keyword. I am
able to INNER JOIN 2 tables, but I am not sure of the syntax for 3 or more
tables. Can someone please show me an example for that ?

TIA

------=_Part_13697_8905503.1209912005920
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

<div>Hello</div>
<div>&nbsp;</div>
<div>When I needed to join tables I always used the equal syntax (ie.
SELECT id from foo,fee where id.foo=id.fee)</div>
<div>&nbsp;</div>
<div>To my understanding, it is preferred to use the INNER JOIN keyword. I
am able to INNER JOIN 2 tables, but I am not sure of the syntax for 3 or
more tables. Can someone please show me an example for that ?</div>
<div>&nbsp;</div>
<div>TIA</div>
<div>&nbsp;</div>

------=_Part_13697_8905503.1209912005920--
 




 4 Posts in Topic:
Need help with INNER Join
magawake@[EMAIL PROTECTED  2008-05-04 10:40:05 
Re: Need help with INNER Join
fbax@[EMAIL PROTECTED] (  2008-05-04 10:52:38 
Re: Need help with INNER Join
nobs@[EMAIL PROTECTED] (  2008-05-04 16:52:13 
Re: Need help with INNER Join
magawake@[EMAIL PROTECTED  2008-05-04 20:12:31 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan13V112 Thu Jul 24 12:17:31 CDT 2008.