Self-Join

[Rakesh Mahajan]

I have three tables. The first table is the samplesettable and every sample that I have has an entry in this table. Each sample may contain one or more integers and/or strings. Strings are stored in the stringtable and integers in the integertable. Each entry in the integer/string table has a link that relates it to the samplesettable. I am trying to build a query that looks something like the following:

Select Distinct sourceId from samplesettable as s1
Inner Join samplesettable as s2 On integertable.link = s2.link
Inner Join stringtable.link On s1.link = stringtable.link
Where integertable.name = 'someIntegerVariablesName'
And stringtable.name = 'SomeStringVariableName'

This query just hangs. There are about 100 samples totally with about 500 integer entries and 500 string entries. I am using MySQL 4.0.10 with the ODBC driver 3.51 with ASP.NET

The objective of the query is to find some sources which are of a certain type (borne out of the fact that they provide a certain integer sample) and then find the value for just these sources for a string sample.

Your help is appreciated.

Thanks,

RM