Required Query help

[mathaj]

Hi,

I needed an urgent help to fire a sql .I have two tables a Loan Table and Conditions table. The tables have a one to many relationship. So for a loan i can have many conditions.

My requirement is that i have to join the two tables so as to get all the cleared conditions for loan. If any one conditions is not cleared don't pick the loan.

Can anyone help me on this.

Thanks

[rushdishams]

may i know some of the details of your tables like the columns of those 2 tables?