[thelist] SQL question

Ken Schaefer ken at adOpenStatic.com
Thu Feb 27 23:20:00 CST 2003

If a.CertType is not required, then what rows from Certtypes do you want to
return when a.CertType is not set?

Perhaps if you could give us some sample data (a few rows from each table),
plus what you want the expected output to be, we can help you write the


From: "noah" <noah at tookish.net>
Subject: [thelist] SQL question

: This is ASP querying an Access database. It should be easy, but I've been
: away from this stuff for a while can't get my head around it.
: I have a query like this:
: SELECT * FROM Gem a, Shapes b, CertTypes c WHERE a.Shape = b.Shape AND
: a.CertType = c.CertType AND NumberOfStones > 0 ORDER BY AverageSize
: I need to test c.Description later in the script, hence the a.CertType =
: c.CertType join. The problem is that a.CertType is not a required field,
: and the above query is not returning the records where a.CertType is not
: set. How can I have it return all records, whether a.CertType is set or


More information about the thelist mailing list