Hi,

I dont think it would be possible to make this work using one single query.

I would suggest the following to make it work..

Write a stored proc and use ur...