Neyse örnek açısından ekleyeyim dosya.
SELECT Tablo2.aa, First(tablo1.bb) AS İlkbb
FROM Tablo2 LEFT JOIN tablo1 ON Tablo2.aa = tablo1.aa
GROUP BY Tablo2.aa;
SELECT Tablo2.aa, First(tablo1.bb) AS İlkbb
FROM Tablo2 LEFT JOIN tablo1 ON Tablo2.aa = tablo1.aa
GROUP BY Tablo2.aa;
Bu Konudaki Yorumlar |
Ado Left Join Problem. - Yazar: feraz - 03/01/2021, 22:16
RE: Ado Left Join Problem. - Yazar: berduş - 03/01/2021, 23:00
RE: Ado Left Join Problem. - Yazar: feraz - 03/01/2021, 23:10
RE: Ado Left Join Problem. - Yazar: berduş - 03/01/2021, 23:16
RE: Ado Left Join Problem. - Yazar: berduş - 03/01/2021, 23:22
RE: Ado Left Join Problem. - Yazar: feraz - 03/01/2021, 23:34
RE: Ado Left Join Problem. - Yazar: feraz - 04/01/2021, 18:43
RE: Ado Left Join Problem. - Yazar: feraz - 04/01/2021, 19:01
RE: Ado Left Join Problem. - Yazar: berduş - 05/01/2021, 09:35
RE: Ado Left Join Problem. - Yazar: feraz - 05/01/2021, 10:50
RE: Ado Left Join Problem. - Yazar: berduş - 05/01/2021, 11:25
RE: Ado Left Join Problem. - Yazar: feraz - 05/01/2021, 19:58
RE: Ado Left Join Problem. - Yazar: berduş - 05/01/2021, 20:03
RE: Ado Left Join Problem. - Yazar: feraz - 05/01/2021, 20:03
RE: Ado Left Join Problem. - Yazar: feraz - 10/01/2021, 01:10
|