Select query - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

Select query

Author

Topic

godspeedba
Yak Posting Veteran

90 Posts

Posted - 2008-10-20 : 06:40:23

Whats wrong with the below, I get the message
Incorrect syntax near the keyword 'AND'

@rating int

SELECT property_id
from tb_ratings_mapper
WHERE
(SELECT *
FROM tb_ratings
WHERE tb_ratings_mapper.rating_id = tb_ratings.ratings_id
AND tb_ratings.rating_mask_id = @rating)

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-10-20 : 06:44:18

quote:
Originally posted by godspeedba

Whats wrong with the below, I get the message
Incorrect syntax near the keyword 'AND'

@rating int

SELECT property_id
from tb_ratings_mapper
WHERE EXISTS
(SELECT *
FROM tb_ratings
WHERE tb_ratings_mapper.rating_id = tb_ratings.ratings_id
AND tb_ratings.rating_mask_id = @rating)

missed EXISTS clause

godspeedba
Yak Posting Veteran

90 Posts

Posted - 2008-10-20 : 06:49:13

This has been bothering me for hours, it took you 10 secs, THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-10-20 : 06:55:39

quote:
Originally posted by godspeedba

This has been bothering me for hours, it took you 10 secs, THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU

welcome

Often you need a fresh pair of eyes to spot things like that. glad that i could spot it out for you.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources