Results 1 to 3 of 3
Thread: MSSQL
Hybrid View
-
3rd February 2011 19:07 #1Registered User
Join Date: Feb:2011
Location: Sofia
Posts: 2
MSSQL
,
MSSQL2008:
"Join" , - -, (. - , ).
- , , .( -, )
- , 12- .
, -, .
, .
-
3rd February 2011 19:22 #2
-
4th February 2011 14:40 #3Registered User
Join Date: Feb:2011
Location: Sofia
Posts: 2
:
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.




Reply With Quote

Lenovo ThinkPad 15 IdeaPad 15
5th May 2023, 22:16 in