Results 1 to 3 of 3

Thread: MSSQL

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Registered User
    Join Date: Feb:2011
    Location: Sofia
    Posts: 2

    MSSQL

    ,
    MSSQL2008:
    "Join" , - -, (. - , ).
    - , , .( -, )
    - , 12- .
    , -, .
    , .

  2. #2
    Banned haste's Avatar
    Join Date: Mar:2006
    Location:
    Posts: 759
    , ?

    , !

  3. #3
    Registered User
    Join Date: Feb:2011
    Location: Sofia
    Posts: 2
    Quote Originally Posted by haste View Post
    , ?

    , !

    :

    select distinct *
    from tblcompanies c
    inner join tblCompanies2Administrators ad on ad.idatom=c.idatom
    inner join tblpersons p on p.idatom=ad.idrelated
    inner join tblDic_Base db on ad.IdPosition =db.ID
    inner join tblDic_Baselng dbl on db.id =dbl.IdParent
    Where c.fiscalcode in ('000694724',
    '000697179',
    '000741106',
    '000750062',
    '000818143')
    and (dateend is null or dateend>GETDATE() )
    and (dbl.IdCulture = 3)
    and (IdPosition in ('3213115','3213058', '3213126', '3213114', '3213055', '3213056', '3213127', '3213097', '3213062', '3213132', '3213116', '6684673', '3213063', '3213070', '3213060'))
    order by fiscalcode desc

    "fiscalcode" .
    "IdPosition" , - ..
    Last edited by cstoian; 7th February 2011 at 15:45.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Copyright © 1999-2011 . .
iskamPC.com | mobility.BG | Bloody's Techblog | | 3D Vision Blog |