Mysql conditions in accordance with the conditions of matching step by step-CodePudding

If (a table contains the specified user) continued to match the next data
Else does not contain a table named user, to match the b table users, if we can match, then the data meet the requirements, a table to match the next data, if there are no match to the specified user b table, a table this record does not meet the requirements, continue to match the next data
Change logic without a stored procedure, use SQL statements can be implemented? How to implement, please everyone a great god answer, thank you very much

CodePudding user response:

reference

refer to the following question method, help to improve the probability of the question to get accurate answer

1. Provide test data sample (do not map to the text is posted, so others can be tested directly copied to your own EXCEL)
2. Based on these examples data correct results are you looking for?
3. Describe how the results, the algorithm, as far as possible need not "jargon".
4. For example, when you need to fully don't other people's methods, the results say "I'm sorry, there is a"
5. One-time finish problem description, don't points several section, or section of the words in the QQ more easily by other speech separation,

CodePudding user response:

"The else does not contain a table to specify user, to match the b table users, if we can match, is a table that the data meet the requirements, continue to match the next data", don't understand the problem, if a table does not contain the specified user, with the b table match, if we can match, a table in the year they meet the requirements, when a table does not contain the data!!!!!! In addition, you need to match if there is a list of data table c?