SELECT
A.league_id AS league_id,
A.clubteam_id AS clubteam_id,
A.clubteam_name AS clubteam_name,
A.clubteam_kana AS clubteam_kana,
A.prefecture_id AS prefecture_id,
A.gender AS gender,
A.create_user AS create_user,
TO_CHAR(A.create_date, 'YYYY/MM/DD HH24:MI:SS') AS create_date,
A.update_user AS update_user,
TO_CHAR(A.update_date, 'YYYY/MM/DD HH24:MI:SS') AS update_date,
A.delete_flag AS delete_flag,
B.league_name AS league_name,
B.display_order AS display_order,
B.prefecture_nc AS prefecture_nc,
B.gender_nc AS gender_nc,
C.prefecture AS prefecture_name,
D.user_name AS create_user_name,
E.user_name AS update_user_name
FROM clubteam_master A INNER JOIN league_master B ON A.league_id = B.league_id
LEFT OUTER JOIN prefecture_master C ON A.prefecture_id = C.prefecture_id
LEFT OUTER JOIN user_info D ON A.create_user = D.user_id
LEFT OUTER JOIN user_info E ON A.update_user = E.user_id
WHERE A.clubteam_id = 658 AND D.delete_flag='0' AND E.delete_flag='0' AND D.status_id='1' AND E.status_id='1'; クエリ実行エラー
SELECT
A.clubteam_id AS clubteam_id,
A.history_id AS history_id,
A.clubteam_summary AS clubteam_summary,
A.clubteam_record AS clubteam_record,
A.clubteam_feature AS clubteam_feature,
A.create_user AS create_user,
TO_CHAR(A.create_date, 'YYYY/MM/DD HH24:MI:SS') AS create_date,
A.update_user AS update_user,
TO_CHAR(A.update_date, 'YYYY/MM/DD HH24:MI:SS') AS update_date,
B.league_id AS league_id,
B.clubteam_name AS clubteam_name,
B.clubteam_kana AS clubteam_kana,
B.prefecture_id AS prefecture_id,
B.gender AS gender,
C.user_name AS create_user_name,
D.user_name AS update_user_name
FROM team_info A INNER JOIN clubteam_master B ON A.clubteam_id = B.clubteam_id
LEFT OUTER JOIN user_info C ON A.create_user = C.user_id
LEFT OUTER JOIN user_info D ON A.update_user = D.user_id
WHERE A.clubteam_id = AND C.delete_flag = '0' AND D.delete_flag = '0' AND C.status_id = '1' AND D.status_id = '1'
ORDER BY A.clubteam_id ASC,A.history_id DESC LIMIT 30 OFFSET 0 クエリ実行エラー
SELECT COUNT(*) AS all_cnt
FROM team_info A INNER JOIN clubteam_master B ON A.clubteam_id = B.clubteam_id
WHERE A.clubteam_id =
;
バスケットボールコミュニティRokyu.Net
