Re: left join

Mon, 31 Jul 2006 23:55:26 -0700 


Hello, Alexander!
You wrote to Horsun Vlad on Tue, 1 Aug 2006 12:41:54 +0600:

AAV> select T1.ID, T2.ID, TJ.IDS
AAV>    from T1, T2
AAV>    left join TJ on T2.ID=TJ.ID
AAV>    where T2.ID=T1.ID

Для пущей наглядности:
select T1.ID, T2.ID, TJ.IDS
  from T1 left join TJ on T1.ID=TJ.ID,
  T2
  where T2.ID=T1.ID

Удач
--
Alexander A. Venikov, Tobolsk, Russia
Real e-mail address is venix<angry_dog>tn<dot>tob<dot>ru

Ответить