-
March 8th, 2012, 02:01 PM
#1
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.
-
March 8th, 2012, 02:35 PM
#2
Re: ISSUE: Every derived table must have its own alias
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|