�������� �� ������� ����������� ������...

[Grishko Aleks]

úÄÒÁÓÔ×ÕÊ, All!!!
 ðÏÍÏÇÉÔÅ ÐÏÖÁÌÕÓÔÁ Ó ÓÏÅÄÉÎÅÎÉÍ ÍÎÏÖÅÓÔ×Á ÍÅÌËÉÈ ÔÁÂÌÉÃ.
åÓÔØ ÎÅÓËÏÌØËÏ ÔÁÂÌÉÃ :
zaiavlenie  ,  chelovek  , suda , dokument , adresa
óÏÏÔÎÏÛÅÎÉÅ ÍÅÖÄÕ ÔÁÂÌÉÃÁÍÉ
zaiavlenie  1..1  chelovek
chelovek  1..n ÏÓÔÁÌØÎÙÅ ÔÁÂÌÉÃÙ
ôÒÅÂÕÅÔÓÑ ÐÏ ÎÏÍÅÒÕ ÚÁÑ×ÌÅÎÉÑ ×ÙÔÁÝÉÔØ  ÄÁÎÎÙÅ ×ÓÅ ÏÓÔÁÌØÎÙÅ ÄÁÎÎÙÅ × ÏÄÎÕ 
ÓÔÒÏÞËÕ .
÷ ÐÒÉÎÃÉÐÅ ÅÓÌÉ Ë ÐÒÉÍÅÒÕ ÄÌÑ ÄÁÎÎÏÇÏ ÞÅÌÏ×ÅËÁ ÅÓÔØ ÎÅÓËÏÌØËÏ ÁÄÒÅÓÏ×, ÔÏ 
ÍÏÖÎÏ ÓÄÅÌÁÔØ ÔÁË

select  * from
zaiavlenie z ,  chelovek ch ,  suda s, dokument dok,
adresa ad , adresa ad2
where z.id = ch.id_zayavlenie and  z.id_suda = s.id_s and
ch.id = dok.id_chelovek and  ad.id_chelovek = ch.id
and z.nomer_zaiavlenia = '262222222222222222222' and ad.propiska_fakt = 
'ðòïðéóëá'
and ad2.propiska_fakt = 'æáëôéþåóëéê'
ôÁËÏÊ ×ÁÒÉÁÎÔ ÍÅÎÑ ×ÐÒÉÎÃÉÐÅ ÕÓÔÒÁÉ×ÁÅÔ (ÚÁÐÒÏÓ ÔÒÅÂÕÅÔÓÑ ÄÌÑ ÐÏÓÌÅÄÕÀÝÅÊ 
ÕÔÉÌÉÚÁÃÉÉ × ÆÁÓÔÒÅÐÏÒÔÅ, ÔÁË ÞÔÏ ÁÂÓÏÌÀÔÎÏ ×ÓÅ ÐÏÌÑ ÎÅ ÔÒÅÂÕÀÔÓÑ)

îÏ × ÜÔÏÍ ÓÌÕÞÁÅ ÅÓÌÉ ÏÔÓÕÔÓÔ×ÕÅÔ Ë ÐÒÉÍÅÒÕ ÆÁËÔÉÞÅÓËÉÊ ÁÄÒÅÓ, ÔÏ ÚÁÐÒÏÓ 
×ÙÄÁÅÔ ÐÕÓÔÕÀ ÓÔÒÏËÕ....
ô.Ï ÓÏÅÄÉÎÅÎÉÅ ÔÒÅÂÕÅÔÓÑ ÄÅÌÁÔØ  left join, ÎÏ ËÁË ÜÔÏ ÐÒÁ×ÅÌØÎÏ ÓÄÅÌÁÔØ ÄÌÑ 
ÎÅÓËÏÌØËÉÈ ÔÁÂÌÉÃ?? (ÒÁÎØÛÅ ÂÏÌØÛÅ 2 ÔÁÂÌÉÃ  ÞÅÒÅÚ left join ÎÅ ÓÏÅÄÉÎÑÌ:) )

úÁÒÁÎÅÅ ÏÇÒÏÍÎÏÅ ÓÐÁÓÉÂÏ!