SQLize Online / PHPize Online  /  SQLtest Online

CREATE TABLE client_info ( id INT PRIMARY KEY, siebel_id_le VARCHAR(255) ); CREATE TABLE idents_info ( id INT PRIMARY KEY, siebel_id VARCHAR(255), bis_id VARCHAR(255), bis_branch VARCHAR(255) ); CREATE TABLE card_info ( id INT PRIMARY KEY, bis_id VARCHAR(255), bis_branch VARCHAR(255), bin_rang VARCHAR(255), profile VARCHAR(255) ); INSERT INTO client_info (id, siebel_id_le) VALUES (1, 'A'), (2, 'B'), (3, 'C'), (4, 'D'); INSERT INTO idents_info (id, siebel_id,bis_id,bis_branch) VALUES (1, 'A', 'A1', '1'), (2, 'A', 'A2', '2'), (3, 'A', 'A3', '3'), (4, 'B', 'B1', '1'), (5, 'B', 'B2', '2'), (6, 'B', 'B3', '3'), (7, 'C', 'C1', '1'), (8, 'C', 'C2', '2'), (9, 'C', 'C3', '3'), (10, 'D', 'D1', '1'), (12, 'D', 'D3', '3'); INSERT INTO card_info (id, bis_branch,bis_id,bin_rang, profile) VALUES (1, '1', 'A1', '22003905', 'FFF1'), (2, '2', 'A1', '22003905', 'FFF2'), (3, '3', 'B3', '22003905', 'FFF3'), (4, '2', 'A1', '22003905', 'FF4'), (5, '1', 'C2', '22003905', 'FFF5'), (6, '3', 'B1', '22003905', 'FFF6'); SELECT profile from card_info card outer join (SELECT siebel_id_le, i.bis_id bis_id, i.bis_branch bis_branch from client_info c join idents_info i on c.siebel_id_le = i.siebel_id) s on s.bis_id = card.bis_id AND s.bis_branch = card.bis_branch;