As the key point of database operation, data query has always been the focus of learning, multi table query is one of the most important and difficult points to learn. This paper discusses on the advantages and disadvantages of three ways to query in multi table: SQL statement, view and storage procedure.