I found the function is COALESCE. But I still only get 66 records not 70.

My situation is this.

I have a table that has 70 item definitions in it (myDefTable).

I have a table that stores records of Assy Index Numbers, item definitions, status, comments (myItemStatusTable).

I want to create a list(cursor) that shows all of the item definitions and where records match to show the status and comments values for a particular Assy Index Number.

I hope this makes sense.