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 t1( id VARCHAR(1) ); INSERT INTO t1(id) VALUES ('a'); INSERT INTO t1(id) VALUES ('b'); INSERT INTO t1(id) VALUES ('c'); INSERT INTO t1(id) VALUES ('d'); CREATE TABLE t2( id VARCHAR(1) ,col2 INTEGER ); INSERT INTO t2(id,col2) VALUES ('a',1); INSERT INTO t2(id,col2) VALUES ('a',2); INSERT INTO t2(id,col2) VALUES ('a',3); INSERT INTO t2(id,col2) VALUES ('a',4); INSERT INTO t2(id,col2) VALUES ('d',1); select * from t1 inner join t2 on t2.col2 > 0;

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

Copy Clear