Posts by Mário Onofre Lemos • 3 points
2 posts
-
0
votes1
answer55
viewsQ: how do Insert a foreign key that is inside a foreign key?
I intend to do Insert in the salary column and table function_name function which is foreign key in department table and this table is foreign key in official table... But the two columns salary and…
sqlasked Mário Onofre Lemos 3 -
-3
votes1
answer56
viewsQ: How to make two Join Inner in one table?
CREATE TABLE FUNCAO ( ID_FUNCAO INT IDENTITY(1,1), NOME_FUNCAO VARCHAR(100), SALARIO VARCHAR(100), DATA VARCHAR(100), CONSTRAINT PK_FUNCAO PRIMARY KEY (ID_FUNCAO) ) CREATE TABLE DEPARTAMENTO (…