View Single Post
  #5 (permalink)  
Old April 10th, 2010, 03:53 PM
sg48 sg48 is offline
Authorized User
 
Join Date: Jun 2003
Location: , , .
Posts: 54
Thanks: 1
Thanked 0 Times in 0 Posts
Default I think your analysis is right on

I agree with you. The problem is that BuyerAgent is in the 2nd table. I wasn't sure how to bind to both tables although I'm sure it can be done.

Also, I knew that combining my SELECTS into one query would solve the problem but
I wasn't sure how to do it. What you just sent looks excellent. I will try it (it may take a while because I have gone past this point and want to make sure I don't mess everything up. Thank you for your insight. Your explanation was extremely clear and helpful. Thank you. - Steve