i am not getting correct email from the query . what can be a reason

Question

question

sameed asked Mar 31, '15

i am not getting correct email from the query . what can be a reason

cms_user(user_id, email, password,type) cms_reseller_slots(reseller_id , slots) cms_Credit_transfer(transfer_id, sender_id, receiver_id) these are the three tables. i want to get email id of receiver_id i have written the below query but not getting any result, if getting , they are not correct SELECT u.email FROM cms_user u JOIN cms_reseller_slots r ON ( u.user_id = r.reseller_id ) JOIN cms_credit_transfer c ON ( c.sender_id = r.reseller_id ) WHERE r.reseller_id =1 LIMIT 0 , 30;

mysql query hints

4

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

sameed commented · Mar 31, 2015 at 12:21 PM

just zero results. even in some r.reseller_id it is giving the result but thats not matching the correct email address in user table

0 ·

sameed commented · Mar 31, 2015 at 12:30 PM

with left join its giving some results, but still not giving all

0 ·

Conan commented · Mar 31, 2015 at 03:36 PM

if you want the email for the receiver_id shouldn't the last join be to c.receiver_id?

0 ·

sameed commented · Mar 31, 2015 at 04:59 PM

Yeah also tried that c.reciever_id too , actually i got the problem sorted, the content must also b entered explicitly in other tables,. thanks a lot for all ur replies. really appreciated

0 ·

Answer 1 · 2015-03-31T12:08:23Z

JohnM answered Mar 31, '15

With the inner joins, are there corresponding records in the cms_reseller_slots & cms_credit_transfer tables? Any error message or just zero results?

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

question