SELECT
sample_user.user_id,
sample_user.name,
prefecture.prefecture_name
FROM sample_user
INNERJOIN user_prefecture
ON user_prefecture.user_id = sample_user.user_id
INNERJOIN prefecture
ON prefecture.prefecture_id = user_prefecture.prefecture_id
WHERE prefecture.prefecture_id IN (1, 2);
SELECT
sample_user.user_id,
sample_user.name,
prefecture.prefecture_name
FROM sample_user
INNERJOIN user_prefecture
ON user_prefecture.user_id = sample_user.user_id
INNERJOIN prefecture
ON prefecture.prefecture_id = user_prefecture.prefecture_id
AND prefecture.prefecture_id IN (1, 2);
SELECT
sample_user.user_id,
sample_user.name,
prefecture.prefecture_name
FROM sample_user
LEFTJOIN user_prefecture
ON user_prefecture.user_id =sample_ user.user_id
LEFTJOIN prefecture
ON prefecture.prefecture_id = user_prefecture.prefecture_id
AND prefecture.prefecture_id IN (1, 2);
public record SampleRequestDto(
@Schema(description = "文字列のパラメータ", example = "文字列")
String stringField,
@Schema(description = "Integer型のパラメータ", example = "1")
Integer integerField,
@Schema(description = "Long型のパラメータ", example = "2")
Long longField
) {
}
public record SampleRequestDto(
@Parameter(description = "文字列のパラメータ", example = "文字列")
String stringField,
@Parameter(description = "Integer型のパラメータ", example = "1")
Integer integerField,
@Parameter(description = "Long型のパラメータ", example = "2")
Long longField
) {
}