开发者

Why if I filter (WHERE=) a row to be equal to a value then in the results I get different values?

开发者 https://www.devze.com 2023-03-10 18:12 出处:网络
I made a view in IBM, then I linked my ms-access 2003 to that view and made a query like this: select * from my_view where a=\"hey\"

I made a view in IBM, then I linked my ms-access 2003 to that view and made a query like this:

select * from my_view where a="hey"

but in the results I ge开发者_如何转开发t a="hey" as well a="asd"

What may I do?


Use single quotes in literal SQL strings.

SELECT * FROM my_view WHERE a = 'hey'
0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号