I want to create an extra coulmn in crystal report and populate it through query. so i create SQl expression and write query in Editor like this:

query: select projshortName from Projects;

This query returns me an error message i.e.
Error in compiling SQL Expression:
Source: DAO.Database
Description: At most one record can be returned by this subquery.
how I solve this problem.???????