Page is a not externally linkable
- Code, Content, and Presentation
-- Databases
---- how to select state name from states within nested select

sukebe - 5:17 pm on Aug 9, 2010 (gmt 0)


duh, here it is:
SELECT users.company, users.fname, users.lname, users.address1, users.address2, users.city, states.short_name AS 'state', users.zip, users.email FROM users, states where (users.company = 'pamchess' and states.stid = users.state) OR (users.company = 'hess' and states.stid = users.state)

Thread source:: http://www.webmasterworld.com/databases_sql_mysql/4182647.htm
Brought to you by WebmasterWorld: http://www.webmasterworld.com