Trouble of friends to help, thank, I use dedecms, member the main table for dede_member, I added an additional table dede_member_company, one of the two tables associated and the same field for mid, I now the question is: for two tables and dede_member_company province at the same time the mid phase field contains hebei this field, should do the query, use dede: loop label, online waiting for,

CodePudding user response:

SQL statements like this label that, it is recommended that the original poster to related BBS posts for help;

 select * from dede_member join 
Dede_member_company on 
Dede_member. Mid=dede_member_company. Mid 
Hebei where dede_member_company. Provice like '% %' 

CodePudding user response:

W712977084

Junction post rate: 0%

reference

after your questions answered please post.
http://topic.csdn.net/u/20090501/15/7548d251-aec2-4975-a9bf-ca09a5551ba5.html
http://topic.csdn.net/u/20100428/09/BC9E0908-F250-42A6-8765-B50A82FE186A.html
http://topic.csdn.net/u/20100626/09/f35a4763-4b59-49c3-8061-d48fdbc29561.html

8, how to give points and knot stick?
http://bbs.csdn.net/help#post_dispose