我正在使用这个正则表达式
var str = "The requirements of this chapter apply to the following: (1)New buildings or portions thereof used as health care occupancies (see 1.4.1) (2)Additions made to, or used as, a health care occupancy (see 4.6.6 and 18.1.1.4) Exception: The requirement of 18.1.1.1.1 shall not
我正在尝试寻找这样的比赛,比赛中的裁判(他是一名官员)也为主客场球队提供医疗服务(请参阅下面的关系图)。
我已经尝试过了,但没有返回任何记录:
select matches.id,
matches.home,
matches.away,
matches.referee
from matches
join officials on officials.staffid = matches.referee
join medicalservices on medicalservices.team in (matches.home, matches.away)
where medicalservices