Untitled

mail@pastecode.io avatar
unknown
plain_text
2 months ago
251 B
2
Indexable
Never
CREATE TABLE tabB1(
NUMID NUMERIC(5));
INSERT INTO tabB1(NUMID) VALUES (12),(14),(10),(11)
CREATE TABLE tabB2 (NUMID NUMERIC(5));
INSERT INTO tabB2(NUMID) VALUES (13),(11),(15),(12)
SELECT * FROM tabB1 inner join tabB2 on tabB1.NUMID=tabB2.NUMID;
Leave a Comment