Cosmiccradle
Technical User
I've got a table with Arabic newspaper titles and to each title the branch library. All the other insert queries I've made places one new title per branch library, the bottom one overwrites all exsisting titles, instead of each branch having 10 different titles, they now all have 10X the same title. Any thoughts on what I'm doing wrong.
Thanks
INSERT INTO [Arabische Kranten] ( ID, Titel, Vertaling, Frequentie, Uitgave, Prijs, Inhoud, Internetadres, Filiaal, Code )
SELECT [Arabische Kranten].ID, [Arabische Kranten].Titel, [Arabische Kranten].Vertaling, [Arabische Kranten].Frequentie, [Arabische Kranten].Uitgave, [Arabische Kranten].Prijs, [Arabische Kranten].Inhoud, [Arabische Kranten].Internetadres, [Arabische Kranten].Filiaal, [Arabische Kranten].Code
FROM [Arabische Kranten];
Thanks
INSERT INTO [Arabische Kranten] ( ID, Titel, Vertaling, Frequentie, Uitgave, Prijs, Inhoud, Internetadres, Filiaal, Code )
SELECT [Arabische Kranten].ID, [Arabische Kranten].Titel, [Arabische Kranten].Vertaling, [Arabische Kranten].Frequentie, [Arabische Kranten].Uitgave, [Arabische Kranten].Prijs, [Arabische Kranten].Inhoud, [Arabische Kranten].Internetadres, [Arabische Kranten].Filiaal, [Arabische Kranten].Code
FROM [Arabische Kranten];