SELECT xxfs.i01_book_ledger.id as l_id,xxfs.i01_book_ledger.book_id as b_id,xxfs.i01_book_ledger.user_id as u_id,
xxfs.i01_book_info.book_no as b_no,xxfs.i01_book_info.book_name as b_name,
xxfs.i0_user.user_id as u_no,xxfs.i0_user.user_name as u_name FROM xxfs.i01_book_ledger,xxfs.i01_book_info,xxfs.i0_user where b_id = xxfs.i01_book_info.id and u_id = xxfs.i0_user.id and xxfs.i01_book_ledger.status = '1'数据库总是报这样类似的错误:
b_id,或者 u_id无效!
是不是我的as语法有问题啊?
请高手们指出错误,谢谢!
xxfs.i01_book_info.book_no as b_no,xxfs.i01_book_info.book_name as b_name,
xxfs.i0_user.user_id as u_no,xxfs.i0_user.user_name as u_name FROM xxfs.i01_book_ledger,xxfs.i01_book_info,xxfs.i0_user where b_id = xxfs.i01_book_info.id and u_id = xxfs.i0_user.id and xxfs.i01_book_ledger.status = '1'数据库总是报这样类似的错误:
b_id,或者 u_id无效!
是不是我的as语法有问题啊?
请高手们指出错误,谢谢!
xxfs.i01_book_info.book_no as b_no,xxfs.i01_book_info.book_name as b_name,
xxfs.i0_user.user_id as u_no,xxfs.i0_user.user_name as u_name FROM xxfs.i01_book_ledger,xxfs.i01_book_info,xxfs.i0_user where i01_book_ledger.book_id = xxfs.i01_book_info.id and xxfs.i01_book_ledger.user_id = xxfs.i0_user.id and xxfs.i01_book_ledger.status = '1'
这两列的
这是不能用
下面的情况时才可以用阿
select u_id... from
(
SELECT xxfs.i01_book_ledger.id as l_id,xxfs.i01_book_ledger.book_id as b_id,xxfs.i01_book_ledger.user_id as u_id,
xxfs.i01_book_info.book_no as b_no,xxfs.i01_book_info.book_name as b_name,
xxfs.i0_user.user_id as u_no,xxfs.i0_user.user_name as u_name FROM xxfs.i01_book_ledger,xxfs.i01_book_info,xxfs.i0_user where i01_book_ledger.book_id = xxfs.i01_book_info.id and xxfs.i01_book_ledger.user_id = xxfs.i0_user.id and xxfs.i01_book_ledger.status = '1'
)
where u_id ...
所以会报错误