加入查询关系数据(Join Query relational data)

加入查询关系数据(Join Query relational data)

你可以帮我吗？

样本数据：

说明：

TableA is =IDAPK, o Urut(L1), o Tampil (L1), Text Faktor (L1) TableB is =IDBPK, IDAFK, o Urut(L2), o Tampil (L2), Text Faktor (L2) IDAPK=IDAFK (ForeignKkey)

你可以加入使用SQL Server进行查询，就像上图中的结果一样吗？ 我不到自己的逻辑。 谢谢...

can you help me?

Sample Data:

Desc:

TableA is =IDAPK, o Urut(L1), o Tampil (L1), Text Faktor (L1) TableB is =IDBPK, IDAFK, o Urut(L2), o Tampil (L2), Text Faktor (L2) IDAPK=IDAFK (ForeignKkey)

Can you join make query with SQL Server to be like the result in a picture above? I can't find my logic. Thank You...

最满意答案

我到了办法做到这一点。 两个query从两个table然后Union All那些result 。 检查下面的SQL：

Select [o Urut(L1)],[o Tampil (L1)],[Text Faktor (L1)],[o Urut(L2)],[o Tampil (L2)],[Text Faktor (L2)] From ( Select IDAPK As ID,1 As SL,[o Urut(L1)],[o Tampil (L1)],[Text Faktor (L1)],'' As [o Urut(L2)],'' As [o Tampil (L2)], '' As [Text Faktor (L2)] From TableA Union All Select IDAFK As ID,2 As SL,'' As [o Urut(L1)],'' As [o Tampil (L1)],'' As [Text Faktor (L1)],[o Urut(L2)],[o Tampil (L2)],[Text Faktor (L2)] From TableB ) As TableAB Order By ID, SL

输出SQL：

I've found a way to do that. Two query from two table then Union All those result. Check below SQL:

Select [o Urut(L1)],[o Tampil (L1)],[Text Faktor (L1)],[o Urut(L2)],[o Tampil (L2)],[Text Faktor (L2)] From ( Select IDAPK As ID,1 As SL,[o Urut(L1)],[o Tampil (L1)],[Text Faktor (L1)],'' As [o Urut(L2)],'' As [o Tampil (L2)], '' As [Text Faktor (L2)] From TableA Union All Select IDAFK As ID,2 As SL,'' As [o Urut(L1)],'' As [o Tampil (L1)],'' As [Text Faktor (L1)],[o Urut(L2)],[o Tampil (L2)],[Text Faktor (L2)] From TableB ) As TableAB Order By ID, SL

Output the SQL: