Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
test
CREATE TABLE app_1 ( objID int, sheetIDApp1 int, sheetNameApp1 varchar(5) ); CREATE TABLE app_2 ( objID int, sheetIDApp2 int, sheetNameApp2 varchar(5) ); INSERT INTO app_1 (objID, sheetIDApp1, sheetNameApp1) VALUES (1, 1, 'A'); INSERT INTO app_1 (objID, sheetIDApp1, sheetNameApp1) VALUES (2, 1, 'A'); INSERT INTO app_2 (objID, sheetIDApp2, sheetNameApp2) VALUES (1, 2, 'B'); INSERT INTO app_2 (objID, sheetIDApp2, sheetNameApp2) VALUES (3, 2, 'B'); select * from app_1 union all select * from app_2
run
|
edit
|
history
|
help
0
Names
№5
SQL_Joins_Intersect_Except_Union
sql to search database objects' definitions for text
test
Hotel BD
Names
new
TSQL - Unique string generator
Extracting Id No