ariadpg
شنبه 12 فروردین 1385, 22:16 عصر
bank1(cod1,nam1)
bank2(cod2,nam2)
bank3(cod)
field 'cod' mojood dar bank3 mitavanad az 'cod' Hai mojood dar bank1(cod1) Or bank2(cod2) baashad.
agar dar bank3 man 5Ta cod marboot be bank1 va 5Ta cod marboot be bank2 daashteh baasham,
chetori ye Query az bank3(be shekl Query(cod,nam)) begiram ke 'nam' cod Hai mojood dar bank3 raa neshan bedahad.
ya'any dastoor Join marbooteh be che shekl ast?
Query delkhaah man faghat 2Ta field daareh(cod,nam)
bank2(cod2,nam2)
bank3(cod)
field 'cod' mojood dar bank3 mitavanad az 'cod' Hai mojood dar bank1(cod1) Or bank2(cod2) baashad.
agar dar bank3 man 5Ta cod marboot be bank1 va 5Ta cod marboot be bank2 daashteh baasham,
chetori ye Query az bank3(be shekl Query(cod,nam)) begiram ke 'nam' cod Hai mojood dar bank3 raa neshan bedahad.
ya'any dastoor Join marbooteh be che shekl ast?
Query delkhaah man faghat 2Ta field daareh(cod,nam)