Hi, Is there a way to select a common field from

Question

Hi, Is there a way to select a common field from

2 tables so the output conitains only one row?
For example if two tables have fields amount and user_id and I want to select all the amounts from both tables that share the same user_id, but under the same column in the output. So the output has to have one field only and that is the amount.

0

25.11.2019

2 ответов

13 просмотров

Victor Salvador

What will happen to the amount? You want to sum it up? Think about it, you have two tables, both have amount, one is 10, the other is 11... How's that supposed to be presented?

0

26.11.2019

Ibrahim Ngeno · Accepted Answer

Ibrahim Ngeno

Using JOIN ?

0

26.11.2019

Похожие чаты

Hi, Is there a way to select a common field from

2 ответов

Похожие вопросы