ISSUE: Every derived table must have its own alias
CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 2 of 2

Thread: ISSUE: Every derived table must have its own alias

  1. #1
    Join Date
    Mar 2012
    Posts
    2

    Question ISSUE: Every derived table must have its own alias

    I know this is a well known issue but i even cant fix it.

    SELECT *
    From (
    SELECT imageID, sourceNode_id, targetNode_id, edge.description, edge.id
    FROM edge
    LEFT JOIN node_edge ON edge.id = node_edge.edge_id
    WHERE imageID='"+partID+"' AND sourceNode_id IS NOT NULL AND targetNode_id IS NOT NULL
    ORDER BY sourceNode_id
    )
    GROUP BY edge.id



    I want to order before grouped so the expression with the lowest sourceNode "survives" the GROUP .

    Please help me. Big Thx.

  2. #2
    Join Date
    Mar 2012
    Posts
    2

    Re: ISSUE: Every derived table must have its own alias

    Solved

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Windows Mobile Development Center


Click Here to Expand Forum to Full Width

This is a CodeGuru survey question.


Featured


HTML5 Development Center