MySQL getting data from two tables

Question

Im having some issues getting the result I want from two tables

table #1: history customer_id | Action ------------------------ 217 | buy ------------------------ 218 | sell ------------------------ 219 | hold ------------------------ table #2: Customers customer_id | name ---------------------------- 217 | Alan ---------------------------- 218 | Jan ---------------------------- 219 | Rick

I have a really long query now, but essentially I want to add to match the name with the amount. I tried this but it didn't work:

(SELECT action AS action FROM "history` LEFT JOIN ON " customer(customer_id=customer_id)`)

I'm not really familiar with doing queries so any help would be appreciated

Jay Blanchard · Accepted Answer · 2017-07-18 17:53:54Z

2

It should be this:

SELECT h.Action AS action FROM history h LEFT JOIN Customers c ON h.customer_id = c.customer_id

You either need to specify the tables or create an alias with which to associate columns/data.

answered Jul 18, 2017 at 17:53

Jay Blanchard

34.5k17 gold badges82 silver badges130 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Strawberry Over a year ago

Is this the low hanging fruit?

Strawberry Over a year ago

Just checking ;-)

ScaisEdge · Accepted Answer · 2017-07-18 17:52:07Z

Is a simple join

select action from history left join Customers on Customers.Customer_id = history.customer_id

and you can confirm using

select history.customer_id, Customers.Customer_id history.action , Customers.name from history left join Customers on Customers.Customer_id = history.customer_id

Jigar Shah · Accepted Answer · 2017-07-18 17:55:33Z

You can JOIN tables like this:

SELECT history.action AS Action ,Customers.name AS Name FROM `history` LEFT JOIN `Customers` ON history.customer_id = Customers.customer_id;

Collectives™ on Stack Overflow

MySQL getting data from two tables

3 Answers 3

2 Comments

Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

Comments

Comments

Related