Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Query consilidation

 
Bai Shen
Ranch Hand
Posts: 323
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I have a table that references another table in a one to many relationship. I have the name of one of the objects in the table, and I want to find all of the other objects in the table that refer to the same object in the other table as one that I have. It's not as confusing as it sounds. I've gotten it to work with the following setup. I'm just not sure how to make them work as one query instead of two.

 
Tomasz Szymanski
Greenhorn
Posts: 23
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Wouldn't this work?
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic