DekGenius.com
Home
(current)
Dictionary
BOOKS
LYRICS
CHORD
SCRIPT & CODE EXAMPLE
Karaoke language
Search
Go
SCRIPT & CODE EXAMPLE
CODE EXAMPLE FOR SQL
select only distinct values from another table and excluding from current table
INSERT INTO Table2(Id) SELECT DISTINCT Id FROM Table1 WHERE Id NOT IN(SELECT Id FROM Table2);
Source by stackoverflow.com #
PREVIOUS
NEXT
Tagged:
#select
#distinct
#values
#table
#excluding
#current
#table
ADD COMMENT
Topic
COMMENT
Name
3+8 =
Submit