SELECT T_name.name_Id
FROM T_name INNER JOIN
T_Apply ON T_name.name_bookid = T_Apply.Apply_bookid AND
T_Apply.Apply_Id = 123
T_name 中name_bookid 与 T_Apply Apply_bookid 唯一对应 数据都有 就是查不出内容来 是不是这句话有问题?
FROM T_name INNER JOIN
T_Apply ON T_name.name_bookid = T_Apply.Apply_bookid AND
T_Apply.Apply_Id = 123
T_name 中name_bookid 与 T_Apply Apply_bookid 唯一对应 数据都有 就是查不出内容来 是不是这句话有问题?
FROM T_name INNER JOIN
T_Apply ON T_name.name_bookid = T_Apply.Apply_bookid WHERE
T_Apply.Apply_Id = 123
FROM T_name,T_Apply
where T_name.name_bookid = T_Apply.Apply_bookid and
T_Apply.Apply_Id = 123
FROM T_name INNER JOIN
T_Apply ON T_name.name_bookid = T_Apply.Apply_bookid WHERE
T_Apply.Apply_Id = 123
Top
回复人: Leftie(左手,为人民币服务) ( ) 信誉:105 2005-02-16 21:27:00 得分: 0
SELECT T_name.name_Id
FROM T_name,T_Apply
where T_name.name_bookid = T_Apply.Apply_bookid and
T_Apply.Apply_Id = 123
Top
------------------------------
以上两种的都行!但要确定T_Apply.Apply_Id是不是数字类型,字符需要加'123'
FROM T_name,T_Apply
where T_name.name_bookid = T_Apply.Apply_bookid and
T_Apply.Apply_Id = 123
-
比较直观