Difference between two tables

[lyric0n]

I am having difficulty coming up with a SQL statement to do the following...

If I have T1 with rows 1, 2, 3 and T2 with rows 1, 2. How would I create a SQL statement to just show row 3 from T1?

Thanks,
Chris

 

[vbkris]

a self join ought to help you.

can i have some data so that i can provide you with an example???

Known is handfull, Unknown is worldfull

 

[monksnake]

?????

select 3 from T1???

<.

 

[lyric0n]

Sure..

T1:
ID | Name | State
1 | Chris | Ohio
2 | John | Maryland
3 | Sally | Washington

T2:
ID | Name | State
1 | Chris | California
2 | John | Maryland

I guess I should also modify my question a bit, since the State in this case changes, I would need to see records 1 and 3 in my result.

Thanks,
Chris

 

[SQLDenis]

read thru this

http://sqlservercode.blogspot.com/2006/05/sql-compare-without-price-tag.html

it will help you understand what you have to do



Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

 

[monksnake]

I see this as

select a.ID, a.State from T2 a inner join T1 b 
on a.Name = b.Name and a.State != b.State

<.