I am haveing trouble with this SPT. It excludes any records that have a value in the recseq field that does not match my recseq criteria.

testconnString = "Select recseq, descptncd," +;
	" CASE WHEN status Is NULL THEN 0 Else status END As status," +;
	" CASE WHEN cmnt Is NULL THEN '' Else cmnt END As cmnt, clcode From webprddt6.drawmextc1" +;
	" Left Join webprddt6.drawmextc3 On webprddt6.drawmextc3.codeid = webprddt6.drawmextc1.clcode" +;
	" Where (recseq = 52632 Or recseq is NULL) Order By clcode"

First the webprddt6.drawmextc3 table contains no records with a recseq = 52632. However it does contain 4 records with recseq = 69607.

Secnd my desired result is this should return 70 records which is the count of webprddt6.drawmextc1. It however only returs 66 records, excluding the 4 records already existing in the table. How do change the Where filter to include records that might have a different recseq?