SELECT
A.witness_id AS witness_id,
A.game_id AS game_id,
A.witness_name AS witness_name,
A.witness_contents AS witness_contents,
A.create_user AS create_user,
TO_CHAR(A.create_date, 'YYYY年MM月DD日 HH24:MI') AS create_date,
A.update_user AS update_user,
TO_CHAR(A.update_date, 'YYYY年MM月DD日 HH24:MI') AS update_date,
B.game_name AS game_name,
B.game_date AS game_date,
B.league_id AS league_id,
B.broadcast_date AS broadcast_date,
B.team1_id AS team1_id,
B.team2_id AS team2_id,
C.user_name AS create_user_name,
C.image_path,
D.user_name AS update_user_name,
E.clubteam_name AS clubteam_name1,
F.clubteam_name AS clubteam_name2,
E.clubteam_kana AS clubteam_kana1,
F.clubteam_kana AS clubteam_kana2,
B.result1 AS result1,
B.result2 AS result2,
G.prefecture_nc AS prefecture_nc,
G.gender_nc AS gender_nc,
H.prefecture AS prefecture_name1,
I.prefecture AS prefecture_name2,
E.gender AS gender1,
F.gender AS gender2,
A.place
FROM user_witness A INNER JOIN game_master B ON A.game_id = B.game_id
INNER JOIN user_info C ON A.create_user = C.user_id
INNER JOIN user_info D ON A.create_user = D.user_id
INNER JOIN clubteam_master E ON B.team1_id = E.clubteam_id
INNER JOIN clubteam_master F ON B.team2_id = F.clubteam_id
INNER JOIN league_master G ON B.league_id = G.league_id
LEFT OUTER JOIN prefecture_master H ON E.prefecture_id = H.prefecture_id
LEFT OUTER JOIN prefecture_master I ON F.prefecture_id = I.prefecture_id
WHERE A.witness_id = 39
AND C.delete_flag='0' AND C.status_id='1' AND D.delete_flag='0' AND D.status_id='1'
; クエリ実行エラー
SELECT
A.witness_comment_id AS witness_comment_id,
A.witness_id AS witness_id,
A.witness_comment AS witness_comment,
A.create_user AS create_user,
TO_CHAR(A.create_date, 'YYYY年MM月DD日 HH24:MI') AS create_date,
A.update_user AS update_user,
TO_CHAR(A.update_date, 'YYYY年MM月DD日 HH24:MI') AS update_date,
B.game_id AS game_id,
B.witness_name AS witness_name,
B.witness_contents AS witness_contents,
C.user_name AS create_user_name,
D.user_name AS update_user_name
FROM user_witness_comment A INNER JOIN user_witness B ON A.witness_id = B.witness_id
INNER JOIN user_info C ON A.create_user = C.user_id
INNER JOIN user_info D ON A.create_user = D.user_id
WHERE A.witness_id = 39
AND C.delete_flag = '0' AND C.status_id = '1' AND D.delete_flag = '0' AND D.status_id = '1'
ORDER BY A.witness_comment_id DESC
バスケットボールコミュニティRokyu.Net
