select A.id,A.creatdate,A.itemitem,B.name from A inner join B on A.type=B.id
select A.id,A.creatdate,A.itemitem,B.name from A where A.type=B.idselect A.id,A.creatdate,A.itemitem,(select B.name from B where B.id=A.type) from A
1.select A.id,A.creatdate,A.itemitem,B.name from A where A.type=B.id2.select A.id,A.creatdate,A.itemitem,B.name from A inner join B on A.type=B.id3.select A.id,A.creatdate,A.itemitem,(select B.name from B where B.id=A.type) from A
select B.name,creatdate,item,type from A right outer join B on A.id=B.id from B left outer join A on A.id=B.id
select A.id,A.creatdate,A.itemitem,B.name
from A
inner join B on A.type=B.id
from A where A.type=B.idselect A.id,A.creatdate,A.itemitem,(select B.name from B where B.id=A.type)
from A
from A where A.type=B.id2.select A.id,A.creatdate,A.itemitem,B.name
from A inner join B on A.type=B.id3.select A.id,A.creatdate,A.itemitem,(select B.name from B where B.id=A.type)
from A
select B.name,creatdate,item,type
from A right outer join B on A.id=B.id
from B left outer join A on A.id=B.id