Hi! Could we please enable some services and cookies to improve your experience and our website?

SQLize | PHPize | SQLtest

Online Sandbox for SQL and PHP: Write, Run, Test, and Share SQL Queries and PHP Code

A A A
Login    Share code      Blog   FAQ
Copy Format Clear
create table A ( ID SMALLINT, CLIENT VARCHAR(16)); INSERT INTO A VALUES (1, 'BANK1'), (2, 'BANK2'), (4, 'BANK4'), (6, 'BANK6'); create table B ( ID SMALLINT, Payments SMALLINT); INSERT INTO B VALUES (1, 3000), (2, 1000), (3, 2000), (4, 4000), (5, 5000); SELECT A.Client, B.Payments FROM A INNER JOIN B ON A.ID=B.ID;

Stuck with a problem? Got Error? Ask AI support!

Copy Clear