SELECT `ouvrage`.`idspecialite` AS `idspecialite` , `specialite`.`specialite` AS `specialite` , `ouvrage`.`ndordre` AS `ndordre` , `ouvrage`.`titre` AS `titre` , `ouvrage`.`adressebibliographique` AS `adressebibliographique` , `ouvrage`.`exemplaire` AS `exemplaire` , `ouvrage`.`cote` AS `cote`
FROM (
`specialite`
JOIN `ouvrage` ON ( (
`specialite`.`idspecialite` = `ouvrage`.`idspecialite` )))




****************************************creation vue*****************************************
CREATE OR REPLACE
ALGORITHM = UNDEFINED
VIEW `vue_rech_specialite` AS
SELECT `ouvrage`.`idspecialite` AS `idspecialite` , `specialite`.`specialite` AS `specialite` , `ouvrage`.`ndordre` AS `ndordre` , `ouvrage`.`titre` AS `titre` , `ouvrage`.`auteur` AS `auteur` , `ouvrage`.`adressebibliographique` AS `adressebibliographique` , `ouvrage`.`exemplaire` AS `exemplaire` , `ouvrage`.`cote` AS `cote`
FROM (
`specialite`
JOIN `ouvrage` ON ( (
`specialite`.`idspecialite` = `ouvrage`.`idspecialite`
) )
)

***************************************************************************************************