Question:

Return records from a table if they exist on another table.

Answer:

SELECT * FROM [dbo].[Customers]
WHERE [CustomerID] IN (SELECT [CustomerID] FROM [dbo].[Orders])

SELECT DISTINCT C.*
FROM [dbo].[Customers] C INNER JOIN [dbo].[Orders] O
ON C.[CustomerID] = O.[CustomerID]