create or replace view test_view
as select 
TestA.id,
TestB.idno,
TestB.name,
TestB.sex
from TestB left join TestA on TestB.idno=TestA.id;