data that in one table column and not in the other table column

dear all

i have 2 tables, lets say table A and Table B

both tables has column ID

i wonder how can i find records that appears in B.ID and not appear in A.ID

what is the SQL command in this case?

Thnks alot

Please post T-SQL question in the Transact-SQL forum at:

http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=85&SiteID=1

You can use the following query:

SELECT B.ID from B where B.ID NOT IN

(SELECT A.ID FROM A)

And this will return records from B which are not in A

Data Sources

Why do the data sources appear in Report Manager when deploying reports. How can they be hidden from the users?

In the properties window - choose "Hide in list view" - it will not be seen in the list view.
If you want to actually secure them - change the permissions to the data source to not include your end users. Only report publishers need to have access to the datasources.

Tudor

Data Sources

Why do the data sources appear in Report Manager when deploying reports. How can they be hidden from the users?

In the properties window - choose "Hide in list view" - it will not be seen in the list view.
If you want to actually secure them - change the permissions to the data source to not include your end users. Only report publishers need to have access to the datasources.

Tudor

sql