How can we help you today? How can we help you today?

SubQueries in a Select Statement problem

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
0

Comments

5 comments

Sort by
  • dpalazotto
    Has anyone else experienced this issue of the application not working when you have a Sub-Query in a Select List??????
    dpalazotto
    0
  • Matthew.Wilkerson
    Yes, I have experienced this as well.
    Matthew.Wilkerson
    0
  • dpalazotto
    Is anyone from Red-Gate going to lend their thoughts on this subject???
    dpalazotto
    0
  • Eddie D
    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 D
    0
  • tanya
    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
    tanya
    0

Add comment

Please sign in to leave a comment.