Have a look at this books online article about joins http://msdn.microsoft.com/en-us/library/ms190014.aspx
What you probably want to do is join the IDS table to the IDCondition table on the ID columns. If you are still having trouble post what query you have come up with and desired output.
Bob
-----------------------------------------------------------------------------
How to post to get the best help[/url]