Post your SQL query as preformatted text, see Wiki - how to post code on this forum. You can edit your post by clicking the pencil Icon in the bottom right. (I would recommend editing the original post to include everything you put in the second post)
What flavor of DB are you using? How are you testing your query before binding it? Are you testing inside of ignition using the query browser are you using an external database management tool, such as SSMS?