Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

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

Posted on 2006-11-20
2
Medium Priority
?
275 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
2 Comments
 
LVL 143

Assisted Solution

by:Guy Hengel [angelIII / a3]
Guy Hengel [angelIII / a3] earned 100 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 400 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

Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

Question has a verified solution.

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

This post contains step-by-step instructions for setting up alerting in Percona Monitoring and Management (PMM) using Grafana.
In this article, I’ll talk about multi-threaded slave statistics printed in MySQL error log file.
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
Suggested Courses

916 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