467,149 Members | 1,266 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,149 developers. It's quick & easy.

Find Parent Record Where Child Records Contain Same Value

I'm building a view in SQL Server 2000 Enterprize Manager to find any parent supply request records that are "Open" where all of the child detail records are "Completed". The two tables are related via "Request Number".
Oct 7 '08 #1
  • viewed: 1955
Share:
1 Reply
So what is the question? is there any error? or what?
Oct 8 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

By using this site, you agree to our Privacy Policy and Terms of Use.