Click here to Skip to main content
15,904,297 members
Home / Discussions / Visual Basic
   

Visual Basic

 
GeneralRe: Button handler Pin
Luc Pattyn31-Oct-07 14:11
sitebuilderLuc Pattyn31-Oct-07 14:11 
GeneralRe: Button handler Pin
fxcapt31-Oct-07 16:17
fxcapt31-Oct-07 16:17 
QuestionRead/Write PCL Pin
Fingerstyler31-Oct-07 11:52
Fingerstyler31-Oct-07 11:52 
AnswerRe: Read/Write PCL Pin
Dave Kreskowiak1-Nov-07 14:24
mveDave Kreskowiak1-Nov-07 14:24 
GeneralRe: Read/Write PCL Pin
Fingerstyler1-Nov-07 16:13
Fingerstyler1-Nov-07 16:13 
GeneralRe: Read/Write PCL Pin
Dave Kreskowiak1-Nov-07 17:48
mveDave Kreskowiak1-Nov-07 17:48 
GeneralRe: Read/Write PCL Pin
Fingerstyler5-Nov-07 9:00
Fingerstyler5-Nov-07 9:00 
QuestionSQL Assistance with ISNULL Pin
digicd131-Oct-07 9:27
digicd131-Oct-07 9:27 
I am trying to write an SQL statement in .Net to fill a listview. The SQL statement retreives information from two tables. The problem I am having is that one of the keys (subjob) can have a null value. Any records where the second key is null are not retrieved. I found a note on the internet indicating the following;

Programmers should take special care when joining tables on columns that can contain NULL values, since NULL will never match any other value (or even NULL itself), unless the join condition uses explicitly the IS NULL or IS NOT NULL predicates.

Can someone please show me where the ISNULL should go to fix this SQL statement.

SELECT Ordmstr.OrdNum, Ordmstr.JobNum, Ordmstr.SubJob, JobMstr.JobDesc
FROM Ordmstr INNER JOIN JobMstr ON (Ordmstr.JobNum = JobMstr.JobNum) AND (Ordmstr.SubJob = JobMstr.SubJob)

Thank you.


digicd1
AnswerRe: SQL Assistance with ISNULL Pin
pmarfleet31-Oct-07 10:07
pmarfleet31-Oct-07 10:07 
GeneralRe: SQL Assistance with ISNULL Pin
digicd131-Oct-07 10:38
digicd131-Oct-07 10:38 
GeneralRe: SQL Assistance with ISNULL Pin
pmarfleet31-Oct-07 10:50
pmarfleet31-Oct-07 10:50 
QuestionList Boxes Pin
dexter970331-Oct-07 8:59
dexter970331-Oct-07 8:59 
AnswerRe: List Boxes Pin
Dave Kreskowiak31-Oct-07 9:48
mveDave Kreskowiak31-Oct-07 9:48 
GeneralRe: List Boxes Pin
dexter970331-Oct-07 10:37
dexter970331-Oct-07 10:37 
GeneralRe: List Boxes Pin
dexter970331-Oct-07 11:08
dexter970331-Oct-07 11:08 
QuestionAnyone know what creates this ugly thing? Pin
cstrader23231-Oct-07 8:39
cstrader23231-Oct-07 8:39 
AnswerRe: Anyone know what creates this ugly thing? Pin
Dave Kreskowiak31-Oct-07 9:45
mveDave Kreskowiak31-Oct-07 9:45 
AnswerRe: Anyone know what creates this ugly thing? Pin
Luc Pattyn31-Oct-07 10:05
sitebuilderLuc Pattyn31-Oct-07 10:05 
AnswerRe: Anyone know what creates this ugly thing? Pin
Paul Conrad31-Oct-07 14:06
professionalPaul Conrad31-Oct-07 14:06 
QuestionVB6 YO VB.NET Pin
s3rro31-Oct-07 7:37
s3rro31-Oct-07 7:37 
AnswerRe: VB6 YO VB.NET Pin
AliAmjad31-Oct-07 8:03
AliAmjad31-Oct-07 8:03 
GeneralRe: VB6 YO VB.NET Pin
s3rro31-Oct-07 10:23
s3rro31-Oct-07 10:23 
GeneralRe: VB6 YO VB.NET [modified] Pin
John_Adams1-Nov-07 1:03
John_Adams1-Nov-07 1:03 
QuestionMSWebDVD Pin
portreathbeach31-Oct-07 6:30
portreathbeach31-Oct-07 6:30 
AnswerRe: MSWebDVD Pin
Dave Kreskowiak31-Oct-07 6:52
mveDave Kreskowiak31-Oct-07 6:52 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.