Record Exists

[email protected] · September 13th, 2004, 01:38 PM

Hello Everyone and thanks for your help in advance. I am writing an application that needs to search various tables by an ID column to determine if a match exists in any of the tables, and preferably a count of matches. However, SQL is not my strong suit. Can anyone give me some help getting this rolling? Any feedback is greatly appreciated. Thanks.

bmains · September 13th, 2004, 02:03 PM

select count(ID) from Table where field like '%whataever text%'

Something like that...

Brian

[email protected] · September 13th, 2004, 02:20 PM

Sort of except that I need to check multiple tables i.e.

Select Count(*)

Table1, Table2, Table3

Where ID=1

Justin Cave · September 13th, 2004, 02:36 PM

Do you want to know where the match is found, or merely that the match is found?

Code:

SELECT COUNT(*), source
  FROM (SELECT ID, 'table1' source 
          FROM table1
         WHERE ID = 1
        UNION ALL
        SELECT ID, 'table2' source 
          FROM table2
         WHERE ID = 1
        UNION ALL
        SELECT ID, 'table3' source 
          FROM table3
         WHERE ID = 1)
 GROUP BY source

will give you a count of matches by table.

Justin
Distributed Database Consulting, Inc.
http://www.ddbcinc.com/askDDBC