Solved

select all from one table and select one field from another table

Posted on 2006-11-20
2
268 Views
Last Modified: 2008-03-10
Hello

I have this query
SELECT * FROM reg_title_app f, agents a

how can I do something like this
SELECT * FROM reg_title_app f, agents a, company c
but only read one field from company?

I'm using mysql 4.0.27

Thanks,
Sean
0
Comment
Question by:sean-keys
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 143

Assisted Solution

by:Guy Hengel [angelIII / a3]
Guy Hengel [angelIII / a3] earned 25 total points
ID: 17982722
SELECT f.*, a.*, c.company_name FROM reg_title_app f, agents a, company c
0
 
LVL 35

Accepted Solution

by:
Raynard7 earned 100 total points
ID: 17982724
Something like

Select f.*, a.*, c.Field FROM reg_title_app f, agents a, company c where f.id = a.id and a.id2 = c.id2
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Foreword This article was written many years ago, in the days when PHP supported the MySQL extension (http://php.net/manual/en/function.mysql-connect.php).  Today (http://php.net/manual/en/migration70.removed-exts-sapis.php) you would not use MySQL…
By, Vadim Tkachenko. In this article we’ll look at ClickHouse on its one year anniversary.
In this video we outline the Physical Segments view of NetCrunch network monitor. By following this brief how-to video, you will be able to learn how NetCrunch visualizes your network, how granular is the information collected, as well as where to f…
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…

628 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question