-- View: "v_series_export"

DROP VIEW "v_series_export";

CREATE OR REPLACE VIEW "v_series_export"
AS
SELECT
    series.makercd,
    maker.makernm,
    series.seriescd,
    series.seriesnm,
    series.seriesnmkana,
    series.recommenddiv

FROM t_series series
    INNER JOIN t_maker maker
        ON series.makercd = maker.makercd
            AND maker.delflg = FALSE
WHERE series.delflg = FALSE
ORDER BY maker.makernmkana, maker.makercd, series.seriescd;