SQLize Online / PHPize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
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', 'B1', '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'), (13, 'A', 'A1', '2'); INSERT INTO card_info (id, bis_branch,bis_id,bin_rang, profile) VALUES (1, '1', 'A1', '22003904', 'FFF1'), (2, '2', 'A1', '22003906', 'FFF3'), (3, '3', 'B3', '22003906', 'FFF3'), (4, '2', 'A1', '22003906', 'FFF3'), (5, '1', 'C2', '22003907', 'FFF5'), (6, '3', 'B1', '22003904', 'FFF6'); 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; SELECT siebel_id_le, s.bis_id bi, s.bis_branch bb, profile from card_info card 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; SELECT siebel_id_le, i.bis_id bis_id, i.bis_branch bis_branch, profile from client_info c join idents_info i on c.siebel_id_le = i.siebel_id join card_info card on i.bis_id = card.bis_id AND i.bis_branch = card.bis_branch where card.bin_rang in ('22003906'); SELECT c.siebel_id_le, card.profile, COUNT(*) AS occurrence_count FROM client_info c JOIN idents_info i ON c.siebel_id_le = i.siebel_id JOIN card_info card ON i.bis_id = card.bis_id AND i.bis_branch = card.bis_branch WHERE card.bin_rang = '22003906' GROUP BY c.siebel_id_le, card.profile;

Stuck with a problem? Got Error? Ask ChatGPT!

Copy Clear