[thelist] sql statement

Joshua Olson joshua at waetech.com
Wed Mar 30 09:32:33 CST 2005


> -----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 




More information about the thelist mailing list