Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. ben3486

    problem with SQL and Inner Join

    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 =...
  2. ben3486

    problem with SQL and Inner Join

    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
  3. ben3486

    problem with SQL and Inner Join

    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...

Part and Inventory Search

Back
Top