What are the challenges you face when working across database platforms? Take the survey

SubQueries in a Select Statement problem

dpalazottodpalazotto Posts: 8
edited February 17, 2009 5:51PM in SQL Prompt Previous Versions
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


  • Options
    Has anyone else experienced this issue of the application not working when you have a Sub-Query in a Select List??????
  • Options
    Yes, I have experienced this as well.
  • Options
    Is anyone from Red-Gate going to lend their thoughts on this subject???
  • Options
    Eddie DEddie D Posts: 1,792 Rose Gold 5
    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 Davis
    Senior Product Support Engineer
    Redgate Software Ltd
    Email: support@red-gate.com
  • Options

    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.

    Project Manager
    Red Gate Software Ltd
Sign In or Register to comment.