Optimization: For queries described in natural language that require multi-table joins, the accuracy is not high. Is there anything that can be optimized?

[Gavinluo]

Optimization: For queries described in natural language that require multi-table joins, the accuracy is not high. Is there anything that can be optimized? After describing the query requirements for orders and details, I found two problems.

1. The key associated with join is incorrect
2. The associated table is incorrect

What can I do?