I'm trying to select record from Table 1 which has more than one kind of 'Type' in Table 3. There is no common ID between Table 1 and Table 3. But Table 2 has LID that's common to LID in Table 1. Table 2 has SLID that's common to SLID in Table 3.
The query should only select A and C from Table 1 without joining any tables. I can easily do this with python but I need to be able to do this with definition query and without any join.
I know the following query is not correct but I tried variations of it using Group and Count but no luck so far.
LID in (SELECT LID FROM Table1 WHERE LID in (SELECT LID FROM Table2 WHERE SLID in (SELECT SLID FROM Table3 WHERE Type in (SELECT Type FROM Table3 ) GROUP BY LID HAVING COUNT(Distinct Type)>1)))