najeeb
چهارشنبه 21 مرداد 1383, 08:28 صبح
این sql دو جدول رو با هم join میکنه ( درست هم جواب میده ) . می خوام بدونم مشکلی نداره مثلا وقتی سطر های جدولها خیلی زیاد باشن ؟؟؟؟؟؟؟
( sql servere و adodataset )
select distinct l.maqsad,l.gmal,l.mal,count(distinct l.mosalsal) as tire,sum(distinct l.mmal) as Ton,count(distinct b.mosalsal) as Tot_m
from javazL AS l full outer join javazb AS b
on l.maqsad=b.maqsad
group by l.gmal,l.maqsad,l.mal
order by gmal
( sql servere و adodataset )
select distinct l.maqsad,l.gmal,l.mal,count(distinct l.mosalsal) as tire,sum(distinct l.mmal) as Ton,count(distinct b.mosalsal) as Tot_m
from javazL AS l full outer join javazb AS b
on l.maqsad=b.maqsad
group by l.gmal,l.maqsad,l.mal
order by gmal