Data matching

Question

hello folks!    Please let me know how to do that ' Compare two tables and find only matching data and then display the result in sql server.' :)

Abhishek Jaiswal · Answer

heyy!
thank u Ramesh, abrar for ur kind seggestions!
:)

Khan Abrar Ahmed · Answer

Hi for the count you can use below script
Select count(*)
from (
SELECT OrderID FROM Orders INTERSECT SELECT OrderID FROM [Order Details]) a

Abhishek Jaiswal · Answer

okay,
and how to count the number of rows in that table output table?

Ramesh Maruthi · Answer

Hey Abhishek,
Please use the Intersect Keyword  like this between the two tables for an example i want to display the order id from two tables
SELECT OrderID FROM Orders INTERSECT SELECT OrderID FROM [Order Details]
this query gives the common order id's which ar exists in two tables