query error . broken !

Question

0.00/5 (No votes)

See more:

Hi .
why this query does not work ?

SQL

SELECT TOP 50 * FROM 
SELECT  fIDUser1 AS fIDUser FROM UserFeature.Relationship WHERE fIDUser2=5 AND fIDStatus=141
          UNION ALL
          SELECT fIDUser2 AS fIDUser FROM UserFeature.Relationship WHERE fIDUser1=5 AND fIDStatus=141)

when execute show error :

Msg 156, Level 15, State 1, Line 2
Incorrect syntax near the keyword 'FROM'.
Msg 156, Level 15, State 1, Line 4
Incorrect syntax near the keyword 'SELECT'.
Msg 102, Level 15, State 1, Line 4
Incorrect syntax near ')'.

Posted 26-Apr-12 1:53am

Saeid.Babaei86

Updated 26-Apr-12 2:05am

v3

Add a Solution

2 solutions

Solution 1

SQL

SELECT TOP 50 * FROM 
(SELECT  fIDUser1 AS fIDUser FROM UserFeature.Relationship WHERE fIDUser2=5 AND fIDStatus=141
          UNION ALL
          SELECT fIDUser2 AS fIDUser FROM UserFeature.Relationship WHERE fIDUser1=5 AND fIDStatus=141)

should do the trick :

1- The first FROM must be moved outside the parenthesis
2- UNION ALL SELECT SELECT was incorrect

Posted 26-Apr-12 1:58am

phil.o

Comments

Saeid.Babaei86 26-Apr-12 8:06am

not work too !

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Arav Pradeep Gupta · Accepted Answer · 2012-04-26T02:07:00

Solution 2

SQL

SELECT TOP 50 * FROM (

SELECT  fIDUser1 AS fIDUser FROM UserFeature.Relationship WHERE fIDUser2=5 AND fIDStatus=141
 UNION ALL
SELECT fIDUser2 AS fIDUser FROM UserFeature.Relationship WHERE fIDUser1=5 AND fIDStatus=141
) as  Users

Posted 26-Apr-12 2:07am

Arav Pradeep Gupta

Updated 26-Apr-12 4:11am

v4

Comments

Saeid.Babaei86 26-Apr-12 8:11am

Oh thank you ! that is right

Kschuler 26-Apr-12 9:55am

If this solution worked for you, it would be nice of you to mark it as the correct solution so that we can see that your question has been answered.