Here's a "quick and dirty" way.

(Note: I used temp tables in my test. You'll have to mod accordingly)

SELECT Colors.[name]

FROM #FlowerColors FlowerColors

INNER JOIN #Colors Colors

ON FlowerColors.ColorID = Colors.ID

GROUP BY Colors.[name]

HAVING COUNT(DISTINCT...

I've never been comfortable with production data on development environments. I've had to do it in the past, and it never sat well with me. Maybe it's because of the...

Ha!

Well, you, a fellow named Tom(?), and I all used to try to help folks out on another SQL forum about 6 years ago. Tom was a master of Oracle,...

I saw the title and author of the articles and it seemed like old times. 🙂

Jeff! It's been years since we last conversed, but it's good to see you're still...

Thank you, Gail. This is the first article to go into my briefcase. I hope I never need to use it 🙂

Regards,

Mike M