I have 3 tables (A,B,C) and each has an "id" column. I'm trying to create a query that will tell me if any of the three tables has a row where id is a specific value. I could do this as 3 separate queries but I feel like I should be able to do it as one.
Red Flag Submitted
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.