O
O
Optimus2016-12-04 10:17:43
MySQL
Optimus, 2016-12-04 10:17:43

Why SQL query returns empty result?

SELECT t1.email, t2.stat, t3.home
FROM `user` AS t1, `analytics` AS t2, `adress` AS t3
WHERE t1.id = t2.uid = t3.uid

Answer: mysql returned 0 rows, although I know for sure (checked manually) that all 3 tables have rows where the id of the first is 61 and the rest have the same value in uid

Answer the question

In order to leave comments, you need to log in

1 answer(s)
M
Max, 2016-12-04
Pyan @marrk2

maybe anywayWHERE t1.id = t2.uid AND t2.uid = t3.uid

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question