Insert

[goransaler]

hello
I like to an insert from a table to another
like this

INSERT INTO Artist ( Artistnamn )
SELECT DISTINCT mp3id3v1artist
FROM Mp3Cdimport

the problem is that if the artistname
exist in the artist table i don't like it to be inserted

hope for help

 

[PHV]

INSERT INTO Artist (Artistnamn)
SELECT DISTINCT mp3id3v1artist
FROM Mp3Cdimport
WHERE mp3id3v1artist NOT IN
(SELECT Artistnamn FROM Artist);


Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[goransaler]

Thanks alot.
that worked great