SQLCE中查询两个表中的数据怎么写SQL语句呀??
我有两个表:user_Info:user_Id,usr_Name,user_PWD....relationUserGroup:user_Id,group_Id
我想找出组group_Id下的所有人信息,用下面的SQL命令:
SELECT a.*
FROM userInfo AS a INNER JOIN
relationUserGroup AS b ON a.user_Id = b.user_Id AND b.group_Id = 2
ORDER BY a.user_Id
可以从SQL2005里查出结果,但是放到手机里就出错了,为什么呀?谁能帮我重新写一个呀
--------------------编程问答-------------------- 手机- -?不解...
--------------------编程问答-------------------- 不是吧 啥意思 不懂啊 --------------------编程问答-------------------- 楼主的问题解决了吗?我写这样的JOIN语句在SQL2005不能执行呀?你的WINCESQL是哪个版本的? --------------------编程问答--------------------
SELECT userInfo.列1,userInfo.列2
FROM userInfo INNER JOIN
relationUserGroup AS b ON a.user_Id = b.user_Id AND b.group_Id = 2
ORDER BY a.user_Id
把要取数据的列全部写出来 在放到Mobile程序执行 看出错不.... --------------------编程问答--------------------
--------------------编程问答--------------------
SELECT userInfo.列1,userInfo.列2
FROM userInfo INNER JOIN
relationUserGroup ON userInfo.user_Id = relationUserGroup.user_Id AND b.group_Id = 2
ORDER BY userInfo.user_Id
--------------------编程问答-------------------- SELECTuserInfo.*
SELECT userInfo.列1,userInfo.列2
FROM userInfo INNER JOIN
relationUserGroup ON userInfo.user_Id = relationUserGroup.user_Id AND relationUserGroup.group_Id = 2
ORDER BY userInfo.user_Id
FROM
userInfo, relationUserGroup WHERE userInfo.user_Id = relationUserGroup.user_Id AND relationUserGroup.group_Id=2 ORDER BY userInfo.user_Id --------------------编程问答-------------------- 帮顶!!
补充:.NET技术 , C#