1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16
|
CREATE TABLE table1 ( Article INT, Prix INT )
CREATE TABLE table2 ( Article INT, Prix INT )
CREATE TABLE table3 ( Article INT, Prix INT )
INSERT INTO dbo.table1 ( Article, Prix )VALUES (123,25)
INSERT INTO dbo.table1 ( Article, Prix )VALUES (456,30)
INSERT INTO dbo.table1 ( Article, Prix )VALUES (789,50)
INSERT INTO dbo.table2 ( Article, Prix )VALUES (123,25)
INSERT INTO dbo.table2 ( Article, Prix )VALUES (456,40)
INSERT INTO dbo.table2 ( Article, Prix )VALUES (4538,50)
INSERT INTO dbo.table3 ( Article, Prix )VALUES (123,25)
INSERT INTO dbo.table3 ( Article, Prix )VALUES (2268,40)
INSERT INTO dbo.table3 ( Article, Prix )VALUES (4538,50) |
Partager