Hi,

Your solution is an elegant solution. Thanks so much for your quick help!

Tuan

Hi Lowell -

Thanks very much again for your great help with the issue.

Tuan

Sorry, it was a mistype (corrected and indicated in red font) in the updated SQL statement below. With the new query it takes 4 seconds which is better than my...

Hi Lowell -

Thanks very much for your response. I have update the SQL statement as you suggested. Unfortunately, the updated SQL statement took more than 3 minutes to return the same...

Hi Sergiy and Noel -

THanks for your responses and help with this issue. A work around solution for now is to set the primary key on the right column to...

Thank YOU all for your quick help.

Tuan

Hi Gopi -

Thanks for your response. It seems to me that the created_date in the WHERE clause was not the issue. If I removed the ticket.created_date in the WHERE clause...

Hi Jeff -

That helps alot. Thanks very much for your help again.

Tuan

Hi Jeff and Sreejith -

Thanks for your spending your time helped me with the code. I'm going to test with both versions. Regarding performance, is Sreejith's version run faster since...

Hi PW,

THanks very much for your quick help. I will try your code soon.

Tuan

Very helpful. Thanks very much to both David and PW!

Have a great weekend!

Tuan

all my sub-queries return a single value. But my statement didn't compile. How do I correct the above statement?

THanks,

Tuan

Hi Luke -

That was very helpful. Thanks again for your help!

Tuan

Hi Luke -

THannks for your response. I tried to apply your suggestion in my query statement but I got syntax error

Original Query - Works fine

SELECT * FROM my_table

WHERE created_date...

Thanks Nagabhushanam!