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

Comments

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