Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
shankar.adi
Starting Member
2 Posts |
 Posted - 2006-07-18 : 00:41:30
|
| Hi, I have query like this,SELECT dbo.eigendm.eige_id, dbo.eigendm.stor_id, dbo.eigendm.dier_id, dbo.eigendm.pers_id, dbo.eigendm.eige_fokk, dbo.persoon.pers_naam, dbo.adressn.adre_postkde, dbo.adressn.adre_straat, dbo.adressn.adre_toevoeg, dbo.adressn.adre_huisnr, dbo.adressn.adre_plaats, dbo.debteur.debt_telmob, dbo.debteur.debt_telefn, dbo.debteur.debt_website, dbo.debteur.debt_email, dbo.debteur.debt_telefaxFROM dbo.eigendm LEFT OUTER JOIN dbo.debteur ON dbo.eigendm.debt_id = dbo.debteur.debt_id LEFT OUTER JOIN dbo.adressn ON dbo.debteur.adre_id_lo = dbo.adressn.adre_id LEFT OUTER JOIN dbo.persoon ON dbo.eigendm.pers_id = dbo.persoon.pers_idI shouldn't get duplicates of dbo.eigendm.eige_id and dbo.eigendm.pers_idThanks and regards,Shankar |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
|
|
|
|
|
|
|
How to apply distinct on two fields in a table