Current location - Training Enrollment Network - Books and materials - Book borrowing name
Book borrowing name
Table A: borrowing table (including all information)

Select the reader number, name, book number and book from the borrowing table where the reader number is located (select the reader number from the borrowing table and group it according to the counted reader number) > =3)

Two tables: borrowing table and personal information basic table.

Select t 1. Reader number, t 1. Name, t2. Reading, t2. Read from the personal information basic table t 1, and borrow table t2, where t2. Reader number (select the reader number according to the counted reader number from the borrowing table group) > =3) and t 1. Reader number =t2. Reader number.