[thelist] sql statement

[Donnie Blaker]

Well in teh case of the address it should return a match or nothing

>From: "Joshua Olson" <joshua at waetech.com>
>Reply-To: "thelist at lists.evolt.org" <thelist at lists.evolt.org>
>To: <thelist at lists.evolt.org>
>Subject: RE: [thelist] sql statement
>Date: Wed, 30 Mar 2005 10:32:33 -0500
>
> > -----Original Message-----
> > From: Donnie Blaker
> > Sent: Wednesday, March 30, 2005 9:19 AM
> >
> > So let me ask a another question, if no one minds.
> > If I have a query that pulls some information a straight
> > select statement
> > that pulls name occupation salary and then has an address id,
> > can I using an
> > INNER JOIN or an OUTER JOIN to pull that information in the
> > same statement.
> >
> > so that one query would get name occupation salary address1
> > address2 city
> > state zip phone? or would that require two queries?
>
>Donnie,
>
>This can be done in one query, generally.  You would need to decide between
>INNER and OUTER joins depending on whether or not you want records returned
>where there is no matching address.
>
><><><><><><><><><><>
>Joshua Olson
>Web Application Engineer
>WAE Tech Inc.
>http://www.waetech.com/service_areas/
>706.210.0168
>
>
>--
>
>* * Please support the community that supports you.  * *
>http://evolt.org/help_support_evolt/
>
>For unsubscribe and other options, including the Tip Harvester
>and archives of thelist go to: http://lists.evolt.org
>Workers of the Web, evolt !

_________________________________________________________________
On the road to retirement? Check out MSN Life Events for advice on how to 
get there! http://lifeevents.msn.com/category.aspx?cid=Retirement