Psst.. new poll here.
Psst.. new forums here.
Microsoft is blocking us again (TY IP Reputation!) so just use oauth login instead. :)
Paste
Pasted as SQL by asdas ( 9 years ago )
create proc sp_ThongTinDauSach
@isbn int
as
begin
select D.isbn,TuaSach, tacgia, ngonngu, bia, trangthai, count(*)
from DauSach d, Muon m
where d.isbn = m.isbn and
trangthai='Y' and
d.isbn=@isbn
and ma_cuonsach not in ( select ma_cuonsach from muon where isbn=@isbn)
group by d.isbn, TuaSach, tacgia, ngonngu, bia, trangthai
end
Revise this Paste