Home
|
Weblogs
|
Forums
|
SQL Server Links
Search:
Active Forum Topics
|
Popular Articles
|
All Articles by Tag
|
SQL Server Books
|
About
SQL Server Forums
Profile
|
Register
|
Active Topics
|
Members
|
Search
|
Forum FAQ
Register Now
and get your question answered!
Username:
Password:
Save Password
Forgot your Password?
All Forums
Old Forums
CLOSED - General SQL Server
select records from a table that isnt in other
Forum Locked
Printer Friendly
Author
Topic
shifis
Posting Yak Master
Mexico
157 Posts
Posted - 07/06/2006 : 12:53:47
Hi, i got brain freeze and dont know how to solve my problem.
I got 2 tables with the same type of data, what i need is select the records that are in the first table but arent in the second.
Any idea will be helpful.
X002548
Not Just a Number
15586 Posts
Posted - 07/06/2006 : 13:02:07
SELECT * FROM table1 a WHERE NOT EXISTS (SELECT * FROM table2 b WHERE a.key = b.key)
Brett
8-)
Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx
Add yourself!
http://www.frappr.com/sqlteam
Topic
Forum Locked
Printer Friendly
Jump To:
Select Forum
General SQL Server Forums
New to SQL Server Programming
New to SQL Server Administration
Script Library
Data Corruption Issues
Database Design and Application Architecture
SQL Server 2012 Forums
Transact-SQL (2012)
SQL Server Administration (2012)
SSIS and Import/Export (2012)
Analysis Server and Reporting Services (2012)
Replication (2012)
Availability Groups and DR (2012)
Other SQL Server 2012 Topics
SQL Server 2008 Forums
Transact-SQL (2008)
SQL Server Administration (2008)
SSIS and Import/Export (2008)
High Availability (2008)
Replication (2008)
Analysis Server and Reporting Services (2008)
Other SQL Server 2008 Topics
SQL Server 2005 Forums
Transact-SQL (2005)
SQL Server Administration (2005)
.NET Inside SQL Server (2005)
SSIS and Import/Export (2005)
Service Broker (2005)
Replication (2005)
High Availability (2005)
Analysis Server and Reporting Services (2005)
Express Edition and Compact Edition (2005)
Other SQL Server Topics (2005)
SQL Server 2000 Forums
SQL Server Development (2000)
SQL Server Administration (2000)
Import/Export (DTS) and Replication (2000)
Transact-SQL (2000)
Analysis Services (2000)
MSDE (2000)
Development Tools
ASP.NET
Reporting Services Development
Other Development Tools
Site Related Forums
Site Related Discussions
Article Discussion
Poll Discussion
The Yak Corral
Other Forums
SQL Server 6.5 \ SQL Server 7.0
Other Topics
MS Access
ClearTrace Support Forum
Old Forums
CLOSED - General SQL Server
CLOSED - SQL Server 2005/Yukon
--------------------
Home
Active Topics
Frequently Asked Questions
Member Information
Search Page
SQL Server Forums
© 2000-2009 SQLTeam Publishing, LLC
This page was generated in 0.05 seconds.
select records from a table that isnt in other
Forum Locked
Posted - 07/06/2006 : 12:53:47
