Incorrect syntax near the keyword 'AS'

Question

1.00/5 (2 votes)

See more:

I have a table by name student, now I need to filter student table with columns id and name this will result into a another table namely s. In s table I need to get a result of s.id=dbo.toppers.id

(Select id,name from student)
 as s 
on s.id=dbo.toppers.id;

I am getting an error message "Incorrect syntax near the keyword 'AS'"

Posted 1-Jun-11 21:01pm

swathi6589

Updated 1-Jun-11 21:28pm

v2

Add a Solution

4 solutions

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)

Abhinav S · Answer 1 · 2011-06-01T21:10:00

Solution 2

You query definitely looks wrong. I'm not quite sure what you are trying to do. Are you selecting the name of a the student who's id = 5 in a table with alias s?

Then try

Select id.name from student as s where s.id = 5

Posted 1-Jun-11 21:10pm

Abhinav S

Comments

Tarun.K.S 2-Jun-11 3:15am

Oops you had already answered it! 5+

Abhinav S 2-Jun-11 3:20am

No problem. :)

swathi6589 2-Jun-11 3:33am

select id,name from student will result into a table namely x.I need to check the condition with table x

Tarun.K.S 2-Jun-11 4:10am

Well you have updated your answer. Can you check mine if it worked for you?

beginner in C#.net · Answer 2 · 2011-06-01T21:18:00

Solution 4

try dis
if u want to get name means

select name as s from student where id=5

else if u want id means

select id as s from student where id=5

Posted 1-Jun-11 21:18pm

beginner in C#.net

Updated 1-Jun-11 21:21pm

v3

Ruard · Answer 3 · 2011-06-01T21:09:00

Solution 1

select s.id, s.name from student s where s.id="5";

Perhaps helpful for sql syntax:

http://www.w3schools.com/sql/sql_select.asp[^]

Posted 1-Jun-11 21:09pm

Ruard

Tarun.K.S · Answer 4 · 2011-06-01T21:12:00

Solution 3

Hi Swathi,

Can you try this:

SQL

SELECT s.id, s.name FROM student AS s WHERE s.id="5"

UPDATE 2:

Then try this:

SQL

SELECT s.id, s.name 
FROM student AS s
JOIN toppers
ON s.id = dbo.toppers.id

Posted 1-Jun-11 21:12pm

Tarun.K.S

Updated 1-Jun-11 21:33pm

v3

Comments

Tarun.K.S 2-Jun-11 3:22am

Edit: Added s to id and name.

swathi6589 2-Jun-11 5:12am

I think, I am not clear to u. By any query I will get a result in table form,can I use alias name for resulted table.