sqlite复合查询

[wjian20]

sqlite:
table A(aID, aName);
值 1, a1
2, a2
table B(bID, bName);
值 1, b1
2, b2
table C(cID, nameType, nameid); nameType=1存放A表的aID到nameid，nameType=0 存放B表的bID到nameid
值 1, 1, 1
2, 0, 1
3, 1, 2
4, 0, 2

用什么方法根据c表的 nameType, nameid字段可以打印出c表存放的对应A,B的name

[wwwwb]

select * from c left join (select 1 as bz,* from a union all select 0 as bz,* from b ) d on c.nameType=d.bz and c.nameid=d.aID

[ACMAIN_CHM]

select case nameType when 1 then (select aName from a where aID=nameid) when 0...