Multi-table join query scheme & nbsp; now I am working on a function to query data from all creden. these creden are sales creden, there are a total of 7 creden。 and 14 tables. May I ask if you want to perform joint queries, or if you have other better solutions. ------ Solution ------------------ create several views based on query requirements ------ solution multi-table joint query solution
Now, I want to query data from all creden。. these creden。 are sales creden。. There are 7 creden。 and 14 tables. May I ask if you want to perform joint queries, or if you have other better solutions.
------ Solution --------------------
Create several views as required
------ Solution --------------------
Joint query is the basic usage of databases, so you don't have to worry too much about efficiency. The key is to build a reasonable index.
