با سلام
من دو تا از جداولمو باهم join کردم این ارورو میده:
join.jpg
اینم کدم:
try
{
connect.Open();
//SqlDataAdapter insert = new SqlDataAdapter(@"select ReciveKoli.mony,MaliPeyment.MonyPeyment,Kolipeymen t.Mony from ReciveKoli inner join MaliPeyment on ReciveKoli.TarafhesabName=MaliPeyment.TarafhesabNa me inner join Kolipeyment on ReciveKoli.TarafhesabName=Kolipeyment.TarafhesabNa me where kolipeyment.TarafhesabName='" + Tarafhesab.Text + "' and MaliPeyment.TarafhesabName='" + Tarafhesab.Text + "' ", connect);
SqlDataAdapter saeed = new SqlDataAdapter(@"select MR.AccCode as [کدطرف حساب],MR.NameBank+'شماره پیگیری:'+MR.Shp+''+MR.babate,MR.Comm AS شرح
,SUM(MR.mony) AS دریافتی
,SUM(MP.Mony) AS پرداختی
,SUM(MR.mony) - SUM(MP.Mony) AS مانده
From
ReciveKoli MR inner join Kolipeyment MP
ON
MR.AccCode = MP.AccCode WHERE MR.TarafhesabName='" + Tarafhesab.Text + "' group by MR.Acccode ", connect);
DataTable tsaeed = new DataTable(); saeed.Fill(tsaeed);