SELECT * FROM ref_rome_familles F INNER JOIN ref_rome_metiers M ON M.code LIKE CONCAT(F.code,'%');
-- table d'acteurs tbActors {int id, varchar name} -- table de films tbMovies {int id, varchar title, varchar actorsList } -- table de séries TV tbSeries {int id, varchar title, varchar actorsList }
SELECT A.name FROM tbActors A INNER JOIN tbMovies M ON M.actorsList LIKE CONCAT('%', A.name, '%');
SELECT A.name FROM tbActors A INNER JOIN tbSeries S ON S.actorsList LIKE CONCAT('%', A.name, '%');
SELECT * FROM ref_rome_familles F INNER JOIN ref_rome_metiers M ON F.code LIKE CONCAT('%',M.code,'%');
Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre questiontb1 { int id, varchar name, varchar code, varchar description } tb2 { int id, varchar name, varchar code, int value }
SELECT id, name, code FROM tb1 WHERE code = 'ABC123' UNION ALL SELECT id, name, code FROM tb2 WHERE code = 'ABC123';
tb1 {int id, varchar name, varchar description } tb2 {varchar code, varchar label, double price }
SELECT name FROM tb1 UNION ALL SELECT label FROM tb2;