by shigemk2

当面は技術的なことしか書かない

2014-03-29から1日間の記事一覧

union

SQL

結果の結合。 SELECT P1.proc_id, P2.proc_id, P1.anest_name, P2.start_time, +1 FROM Procs AS P1, Procs AS P2 WHERE P1.anest_name = P2.anest_name AND NOT (P2.end_time <= P1.start_time OR P2.start_time >= P1.end_time) UNION SELECT P1.proc_id, …