Inner Join Problem

[ballouta]

Hello

 

I have the table 'members' of the following headers:

 

ID    user              password      reseller

2      malek            123              Y

3      maher            456              N

 

etc...

 

and the table 'rescus' with the following headers:

 

ID      customer      reseller    credits

6        malek          XXX        50

100    Samer        XXX        6

 

i wanna loop and print all members ='Y' and their credits frm the second table, i wrote this query but it is not giving me a correct result:

<?php
$query = "SELECT members.user, rescus.customer, rescus.credits
FROM rescus INNER JOIN members ON rescus.customer = members.user where members.reseller ='Y'";
?>

Please Help

Thank You

[Barand]

That looks as though it would give

[pre]

malek        malek      50[/pre]

[ballouta]

yes this is what i want, do u mean the query is correct?

[Barand]

I haven't tried it but it looks OK.

 

What were you getting for you to say it's incorrect?

[ballouta]

I said it's incorrect because the result is missing few rows, i got three rows while expected 7. I think I have to review the data in the second table and make sure that they are exisit.

 

Thank you

[Barand]

If you are trying to list all members with "Y" even they have no record in "rescus" then you need

 

FROM members LEFT JOIN rescus ON  ....