problem with SQL and Inner Join

[ben3486]

Hi everybody

I'm trying to convert my Access DB to Mysql by using ASP and apparently, Mysql doesn't support Access SQL !!
This is my code I want to export:

SELECT franchise.ID, franchise.societe, franchise.nom, franchise.prenom, franchise.adresse, franchise.cp_ville, franchise.pays, franchise.telephone, franchise.fax, franchise.gsm, suivi_franchise.num_suivi, suivi_franchise.interlocuteur, suivi_franchise.date_suivi, suivi_franchise.suivi, suivi_franchise.remarques

FROM suivi_franchise INNER JOIN (franchise INNER JOIN rel_suivi_franchise ON franchise.ID = rel_suivi_franchise.num_franchise) ON suivi_franchise.num_suivi = rel_suivi_franchise.num_suivi

WHERE (((franchise.ID)=[numfranchise]));

is that someone can help me to resolve this problem??

Ben

 

[swampBoogie]

SELECT franchise.ID,
franchise.societe,
franchise.nom,
franchise.prenom,
franchise.adresse,
franchise.cp_ville,
franchise.pays,
franchise.telephone,
franchise.fax,
franchise.gsm,
suivi_franchise.num_suivi,
suivi_franchise.interlocuteur,
suivi_franchise.date_suivi,
suivi_franchise.suivi,
suivi_franchise.remarques
FROM suivi_franchise INNER JOIN rel_suivi_franchise
ON suivi_franchise.num_suivi = rel_suivi_franchise.num_suivi
INNER JOIN franchise
ON franchise.ID = rel_suivi_franchise.num_franchise
WHERE franchise.ID = <numfranchise>

What is numfranchise?

 

[ben3486]

Thanks for this quick answer !!

Actually, [numfranchise] is a criteria in Access. It gives you the possibility with ASP, to go directly to the appropriate record without reading the others (using command object)

Thank you again
ben

 

[ben3486]

I tried this code inside a query but no records display however I deleted 'where ...'

On the other hand, I tried this code:

SELECT ... FROM franchise
Inner Join rel_suivi_franchise ON franchise.id = rel_suivi_franchise.num_franchise
Inner Join suivi_franchise ON suivi_franchise.num_suivi = rel_suivi_franchise.num_suivi

But only 3 records on 6 display on the screen !!!