Q_指揮者別曲目2
SELECT dbo_曲目.指揮者, dbo_曲目.作曲者, dbo_曲目.曲名, dbo_曲目.演奏者, dbo_曲目.演奏団体, dbo_CD.番号, dbo_CD.[ジャンル]
FROM dbo_CD INNER JOIN dbo_曲目 ON dbo_CD.[CD-ID] = dbo_曲目.[CD-ID]
WHERE (((dbo_曲目.指揮者) Is "奥田宗宏") AND ((dbo_曲目.作曲者) Is Not Null) AND ((dbo_曲目.曲名) Is Not Null))
ORDER BY dbo_曲目.指揮者, dbo_曲目.作曲者, dbo_曲目.曲名;