Unanswered: Please help a noob with some query syntax
First time poster so sorry if this lacks specificity.
All I know about our database is that it is Db2, assuming a fairly recent version. This is a very basic syntax question so i'm hoping the lack of that kind of information won't matter.
As part of a SELECT statement, one of the columns i'm selecting is 'course_outline'. At the moment it is (as it should) returning the actual value within each 'course_outline' cell that I have joined to the 'course' column/table.
Rather than returning the actual 'course_outline' value, I just want to return something that tells me whether or not there is a value in the cell.
Logically it would play out as
course_outline.course_outline <-- (return value 'yes' if cell is not null)
INNER JOIN course_outline ON course_outline.course_id = course.course_id
I have no idea what clause to use to make this happen.
Best Regards, Guy Przytula
Database Software Consultant
Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
Information Server Datastage Certified http://www.infocura.be