Reply
Old 06-21-2014, 06:07 PM   #1 (permalink)
MrF
 
Status: Junior Member
Posts: 3



Default sql query help

here is the database table : Stagiaire(numstagiaire,nom_stag,prenom_stag,adresse,email,#num_groupe) Groupe(num_groupe,nom_groupe,#num_filiere) Filière(num_filiere,nom_filiere) Contrôle(num_controle,date_controle,#num_module) Notation(#numstagiare ,# num_controle,note) Module(num_module,nom_module,masse_horaire_prevue,masse_horaire_réalisé,#numformateur) Formateur(numformateur,nomf,prenomf, num_filiere)

i need query to select all stagiaire columns who have filiere.nom_filiere = "TDM" and in "A" or "B" Groupe.nom_groupe

MrF is offline   Reply With Quote

Reply

Bookmarks

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
C# How do you get each array of SQL SELECT query and use its list of value to query another SELECT query? ThambiMurugan ASP Code/ ASP Codes 2 02-08-2014 11:06 AM
I want to run a query in my Access query database showing all my customers in the US? Alan Databases 0 04-02-2013 06:03 PM
i want to run a query in my Access query database showing all my customers in the US? Alan Databases 0 03-28-2013 11:07 PM
php query and sub query not running it states it has an error.? CharlesKendrickM MySQL Databases 1 10-01-2012 10:37 AM
Which is the primary advantage of creating a new query based on an existing query? Unknown_User Databases 0 04-17-2012 10:37 AM