requte4.sql

来自「a small application in Mysql and Delphi」· SQL 代码 · 共 10 行

CREATE PROCEDURE requte4()
BEGIN
SELECT  * FROM  Membre WHERE  code_personne 
IN (
SELECT  code_personne FROM emprunt NATURAL JOIN film
UNION
SELECT  code_personne FROM emprunt NATURAL JOIN  joue_dans
)  ;
END/