1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33
| CREATE TABLE dbo.maTableA
(
IDmaTableA INT IDENTITY CONSTRAINT PK_maTableA PRIMARY KEY,
maTableA_maColonne VARCHAR(16) NOT NULL
)
GO
INSERT INTO dbo.maTableA VALUES ('toto')
INSERT INTO dbo.maTableA VALUES ('titi')
INSERT INTO dbo.maTableA VALUES ('tutu')
GO
CREATE TABLE dbo.maTableB
(
IDmaTableB INT IDENTITY CONSTRAINT PK_maTableB PRIMARY KEY,
maTableB_maColonne VARCHAR(16) NOT NULL
)
GO
INSERT INTO dbo.maTableB VALUES ('toto')
GO
--SELECT * FROM dbo.maTableA
--SELECT * FROM dbo.maTableB
INSERT INTO dbo.maTableB
SELECT maTableA_maColonne
FROM dbo.maTableA A, dbo.maTableB B
WHERE B.IDmaTableB <> A.IDmaTableA
GO
SELECT * FROM dbo.maTableB |