SubQueries in a Select Statement problem

dpalazotto · February 11, 2009 10:57AM

For whatever reason, the table alias in a Select subquery isnt recognized through Sql prompt 3.

For example

select a.name,(Select b.phone from demo2 b where a.recid = b.recid) as [phone number]

from demo a

dpalazotto · February 12, 2009 10:56AM

Has anyone else experienced this issue of the application not working when you have a Sub-Query in a Select List??????

Matthew.Wilkerson · February 12, 2009 2:53PM

Yes, I have experienced this as well.

dpalazotto · February 13, 2009 5:14PM

Is anyone from Red-Gate going to lend their thoughts on this subject???

Eddie D · February 17, 2009 3:17PM

Thank you for your Live Chat Session earlier this evening.

I have created a support call whose reference is F0019579.

Checking our Bug Tracking System, I suspect that this problem is a known issue. I need to check with the SQL Prompt Development Team to see if we have a fix for the issue or if this problem is scheduled to be fixed in SQL Prompt V4. Once I have the necessary information, I will update this forum post.

Many Thanks
Eddie

tanya · February 17, 2009 5:51PM

Hello,

Due to the technical implications attached to fixing it this has been a known issue with SQL Prompt for sometime now .
However, the good news is we are addressing this issue in V4.0 which is scheduled to be released in Q2 2009.
So the fix is on its way and its not far...if that helps at all

Sorry for the inconvenience caused and thank you for all your patience.

Regards,
Tanya
Project Manager
Red Gate Software Ltd

SubQueries in a Select Statement problem

Comments

Product Learning

Community Forums

Events & Friends

Simple Talk