| Subject: | Re: SQL server - merge table? |
|---|---|
| From: | "paross1" <webforumsuser@xxxxxxxxxxxxxx> |
| Date: | Mon, 18 Feb 2008 15:20:56 +0000 (UTC) |
| Newsgroups: | macromedia.coldfusion.database_access |
Something like this? SELECT * FROM table1 UNION SELECT * FROM table2 t2 WHERE NOT EXISTS(SELECT 1 FROM table1 t1 WHERE t1.ID = t2.ID) Phil |
| <Prev in Thread] | Current Thread | [Next in Thread> |
|---|---|---|
| ||
| Previous by Date: | Re: distinct on more than one field, paross1 |
|---|---|
| Next by Date: | Re: SQL server - merge table?, Mattastic |
| Previous by Thread: | SQL server - merge table?, Mattastic |
| Next by Thread: | Re: SQL server - merge table?, Mattastic |
| Indexes: | [Date] [Thread] [Top] [All Lists] |