内部加入PHP代码MySQL

Question

I'm trying to do some code that retrieves me the total of inscriptions in my database. I have a table with the data for the athlets, and another table with the payment information. But, the problem is when i have a group. If i have a group, 2 or more athlets become a single row in payment table with just the number of the first athlet.

When i try to output the total of inscriptions, a group shows only 1 inscription instead of the real number that could be 2 or more.

At the moment i'm using

$result10 = mysql_query("SELECT * FROM atleta 
     INNER JOIN inscricao ON atleta.id_atleta=inscricao.atleta_id_atleta
     WHERE inscricao.parceiro_id_parceiro ='52'");

Atleta is the table with the data for athlets. Inscricao is the table with the payment info. parceiro_id_parceiro is the access that i used for the inscription.

Answer 1

EDITED try this:

$result10 = mysql_query("SELECT * FROM atleta where atleta.id_atleta =(select inscricao.atleta_id_atleta from  inscricao  WHERE parceiro_id_parceiro ='52'"));