SELECT  a.*,b.*
FROM    TableA a
        FULL JOIN TableB b ON a.ID_col = b.ID_col
WHERE   a.ID_Col IS NULL
        OR b.ID_Col IS NULL;

quote:

---

Originally posted by James K

Perhaps this?

SELECT  a.*,b.*
FROM    TableA a
        FULL JOIN TableB b ON a.ID_col = b.ID_col
WHERE   a.ID_Col IS NULL
        OR b.ID_Col IS NULL;

---

SELECT a.* into C FROM a AS a 
left outer join b AS b
on a.id= b.id
where b.id is null

quote:

---

Originally posted by James K

That is to be expected. When you join on the id column and in the where clause specify that b.id is null, what you are requesting of SQL Server is to return all rows for which there were no matching rows in table b. Since there is no matching row in table b, there cannot be value for the date column in table b for that row as well.

I didn't quite understand the logic you are trying to implement, but it seems like you need to join on something else other than id's. When you say "if the id columns don't match", that means you are (in your thought process) matching a row in table a with a row in table b using some other criterion. What is that criterion? That is what you would need to use in the join clause.

---

quote:

---

Originally posted by James K

It is hard for me to follow the logic and data flow from your description. If you post the table schema and some representative sample data indicating the problem areas, that would help. Take a look at this page if you need help in posting schema and sample data: http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

---