シンプルなＳＱＬの書き方がわかりません。

質問

以下のＳＱＬをシンプルに一つにしたいのですが、どのように書いたらよろしいでしょうか？
どうぞご返答頂けますようお願い申し上げます。

--test1_tblの抽出
select
a1 as a1,
b1 as b1
from a_tbl
where c=1

--test2_tblの抽出
select
a1 as a1,
e1 as e1
from b_tbl
where rowid in
(select min(rowid) from ee group by a1)
and a1 is not null
and a1 !=' '
order by a1

--test1_tblとtest2tblの結合
select
t0.a1 as a1,
t0.b1 as b1,
t1.e1 as e1
FROM
test1_tbl t0,
test2_tbl t1
WHERE (t0.a1 = t1.a1)

回答No.1

nora1962 · ベストアンサー

シンプルじゃないか。
select
t0.a1 as a1,
t0.b1 as b1,
t1.e1 as e1
from
( select
a1 as a1,
b1 as b1
from a_tbl
where c=1 ) t0
join
( select
a1 as a1,
e1 as e1
from b_tbl
where rowid in
(select min(rowid) from ee group by a1)
and a1 is not null
and a1 !=' ' ) t1
on t0.a1=t1.a1

お礼

勉強不足で申し訳ありません。
ありがとうございます！