INNER JOIN+IS NOT NULL probs - SQL Server Forums

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.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

INNER JOIN+IS NOT NULL probs

Author

Topic

MATTXtwo
Starting Member

4 Posts

Posted - 2008-10-16 : 21:54:01

[CODE]SELECT tblPeribadi.Personel_No, tblPeribadi.Nama,tblCompany.Keterangan as Company_Code, tblPeribadi.Jawatan, tblPeribadi.Taraf_Jawatan,
tblGroup.Keterangan AS Kumpulan,tblPeribadi.Gred,tblBusiness_Area.Keterangan AS Business_Area,tblCost_Center.Keterangan AS Kod_Pusat_Kos, tblPeribadi.IC_Baru, tblPeribadi.IC_Lama,
tblPeribadi.Jantina, tblPeribadi.BumiStatus,
CAST(DAY(tblPeribadi.Tarikh_Lahir) AS VARCHAR(2)) + ' ' + DATENAME(MM, tblPeribadi.Tarikh_Lahir) + ' ' + CAST(YEAR(tblPeribadi.Tarikh_Lahir) AS VARCHAR(4)) AS [Tarikh_Lahir],
tblPeribadi.Tempat_Lahir,TblCountry.CDesc as Negara_Kelahiran, tblstate.Statedesc as Negeri_Kelahiran,
tblMaritulStatus.MarStat as Taraf_Perkahwinan,
CAST(DAY(tblPeribadi.Tarikh_Perkahwinan) AS VARCHAR(2)) + ' ' + DATENAME(MM,tblPeribadi.Tarikh_Perkahwinan) + ' ' + CAST(YEAR(tblPeribadi.Tarikh_Perkahwinan) AS VARCHAR(4)) AS [Tarikh_Perkahwinan],
tblreligious.Rel_Denomination as Agama, tblEthnic.EthnicDesc as Bangsa, tblPeribadi.No_EPF, tblPeribadi.No_Socso,
tblPeribadi.No_Tax, tblPeribadi.Email
FROM tblPeribadi INNER JOIN
tblCompany ON tblPeribadi.Company_Code=tblCompany.Company_Code INNER JOIN
tblGroup ON tblPeribadi.Kumpulan = tblGroup.Kumpulan INNER JOIN
tblBusiness_Area ON tblPeribadi.Business_Area = tblBusiness_Area.Business_Area INNER JOIN
tblCost_Center ON tblPeribadi.Kod_Pusat_kos = tblCost_Center.Kod_Pusat_Kos INNER JOIN
TblCountry ON tblPeribadi.Negara_Kelahiran = TblCountry.CShort inner join
tblstate on tblPeribadi.Negeri_Kelahiran=tblstate.region inner join
tblMaritulStatus on tblPeribadi.Taraf_Perkahwinan=tblMaritulStatus.MarCode inner join
tblreligious on tblPeribadi.Agama=tblreligious.relcode inner join
tblethnic on tblPeribadi.Bangsa=tblEthnic.EthnicCode
where tblperibadi.personel_no=@Personel_No[/CODE]
********************************************************************
I need for to select the data from tblPeribadi where some of data is null value and might harm to the inner join table,Iwant to make it ignore the inner join table if the data is null

BRINGING LITE CONTENTS

SimpleSQL
Yak Posting Veteran

85 Posts

Posted - 2008-10-16 : 22:24:41

Which data is NULL that you want to avoid. Can you give some more details like column names, where data might be NULL.

Are you worried about following JOIN cnodition?

tblPeribadi.Company_Code=tblCompany.Company_Code

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources