>>I have a situation that I have been trying to resolve but was unable to up until now. I have a one to many relationships in a SQL where I need to use a condition on the INNER JOIN table. So, for example, the INNER JOIN table might have three records related to one record from the master table in the SQL. But, I need to assure to take only master records where all the INNER JOIN records for that table would satisfy a condition. What could be an example of such a query?
>
>in sql rewrite what you wrote in words
>
>SELECT * FROM MASTER M
> WHERE F1_CONDITION = ALL (SELECT table.F1 FROM Table T WHERE T.Mkey = M.key)
>
Hi Fabio,
Take a look at this blog post by Brad Schulz
ALL, ANY and SOME - The threee Stooges
If it's not broken, fix it until it is.
My Blog