If there is now A, B, C three tables
And relationship for A corresponding multiple B, corresponding to multiple C, B
Facility for later have to query, and I need also to join A table winner in table C key information, or have A leftjoin every query

CodePudding user response:

C should not have A primary key, if just query, you can create A view

CodePudding user response:

LEFTJOIN directly

CodePudding user response:

Can according to you the amount of data to determine if data particularly big, can consider to build, to reduce the number of queries, the associated number, improve the query efficiency