Need a Sql query

[T Senthilnathan]

Hi friends, I have a table like below, account_no linked_acc_no --------- ------------- aaa bbb bbb ccc bbb ddd eee ccc ddd fff fff ggg eee hhh hhh iii xxx zzz xxx yyy vvv www I need a query to select account no which are linked with 'aaa'. So the o/p should be like this, o/p --- bbb ccc ddd eee fff ggg hhh iii any one can help me on this?..

[T Senthilnathan]

Hi friends, I got a solutions. Thanks.

[Pravin Patil Mumbai]

Congrats...

[loyal ginger]

There may be better solutions. They are not likely to be shared if you decide to keep yours to yourself.

[Chris Meech]

I wonder what precipatated the solution. :cool:

Chris Meech I am Canadian. [heard in a local bar] In theory there is no difference between theory and practice. In practice there is. [Yogi Berra] posting about Crystal Reports here is like discussing gay marriage on a catholic church’s website.[Nishant Sivakumar]

[Corporal Agarn]

Just had a flash back from Chemistry 110 - 35 years ago!

[thatraja]

T.Senthilnathan wrote:

I got a solutions.

Glad you got that. BTW why don't you post that solution in your message....Also are you sure your solution is best?

thatraja

---

**My Tip/Tricks
My Dad had a Heart Attack on this day so don't...
**