SELECT id,book_no,book_name
FROM i01_book_info
where id is not in
select book_id from i01_book_ledger where status = '1'数据库报错愿高手解答,不胜感激!
FROM i01_book_info
where id is not in
select book_id from i01_book_ledger where status = '1'数据库报错愿高手解答,不胜感激!
FROM i01_book_info
where id not in
(select book_id from i01_book_ledger where status = '1')
;
FROM i01_book_info
where id not in
(select book_id from i01_book_ledger where status = '1')
;