Ask next everybody hotties how to use SQL statements to the following three tables to merge into a summary table lends_huizong readers borrow information (CODE readers number, DEPT readers college, BOOKID number of books, book classification number, CALL _NO MONTH lending MONTH)
The three tables below
Readers readers information table (CODE readers number, DEPT readers college)
Lends readers borrow form (CODE reader card number, BOOKID number of books, the MONTH lending MONTH)
Books, book information table (BOOKID number of books, CALL_NO book classification number)
Thank you very much

CodePudding user response:

 
Sql Server 
 -- -The Select A.C ODE, a. d. EPT, B.B OOKIDB. The MONTH, Arthur c. ALL_NO Into lends_huizong From readers A 
Inner Join lends B On A.C ODE=biggest ODE 
Inner Join books On C B.B OOKID=mount OOKID 
- My Sql 
The Create Table lends_huizong (
CODE Varchar (20), 
DEPT varhcar (50), 
BOOKIDB varhcar (50), 
The MONTH varhcar (50), 
CALL_NO varhcar (50), 
) 
Insert Into lends_huizong 
The Select A.C ODE, a. d. EPT, B.B OOKIDB. The MONTH, Arthur c. ALL_NO From readers A 
Inner Join lends B On A.C ODE=biggest ODE 
Inner Join books On C B.B OOKID=mount OOKID