how to select data from a table useing values from another table

Question

I want to select data from a table called tbl_users using a value from another table called mergeing and column called donator_1.

I tried the following:

$result = $DBcon->query("SELECT tbl_users.username, tbl_users.email, tbl_users.Phone_number FROM tbl_users,mergeing WHERE mergeing.donator_1= tbl_users.user_id AND mergeing._id = 6");
while($row = $result->fetch_array()) {
  echo '<b>' . $l['user_id'] .'</b><b>' . $l['username'] . '</b>';
}

check out this link, this might help you find the answer. http://stackoverflow.com/questions/725556/how-can-i-merge-two-mysql-tables — Dries Peeters, Mar 12 '17 at 15:39
Look up inner join, I'm guessing its doesn't like From A, B.. Considered very bad form that. — Tony Hopkinson, Mar 12 '17 at 15:42

score 1 · Accepted Answer · edited Mar 12 '17 at 20:33

1

You can try nested queries:

SELECT username, email, Phone_number
FROM tbl_users
WHERE user_id = (SELECT donator_1 FROM mergeing WHERE _id = 6 )

or an inner join :

SELECT username, email, Phone_number
FROM tbl_users
JOIN mergeing ON tbl_users.user_id = mergeing.donator_1
WHERE mergeing._id = 6

edited Mar 12 '17 at 20:33

Robin Daugherty

7,115
4
45
59

answered Mar 12 '17 at 15:53

Shady Atef

2,121
1
22
40

thanks the first one didn't work but the second one did – imm Mar 12 '17 at 18:47

how to select data from a table useing values from another table

1 Answers1