Fields:

Field Name	Common Type	Database Type	Generic Field ID	Array Size	Default	Flags	Comment
condition	LONG	int	8			DIRECT	Commitment condition
description	CHAR	varchar	2	80			Commitment title
due_date	CLK_TIME	datetime	43				Date and time the task must be completed
elm_objid	LONG	int	3			DIRECT	Internal record number
first_name	CHAR	varchar	15	30		SEARCHABLE	Contact first name
id_number	CHAR	varchar	4	255			Unique ID number for the case
last_name	CHAR	varchar	14	30		SEARCHABLE	Contact last name
owner_objid	LONG	int	42			DIRECT	Owner internal record number
parent_objid	LONG	int				DIRECT	Parent internal record number
s_first_name	CHAR	varchar		30			Contact first name
s_last_name	CHAR	varchar		30			Contact last name
type	LONG	tinyint				DIRECT	Dummy field use to store a temporary value
user_objid	LONG	int				DIRECT	Originator internal record number

SQL:

(
SELECT elm_objid, user_objid, id_number, due_date, first_name, first_name, last_name, last_name, description, condition, owner_objid, parent_objid, '0' as type
FROM table_case_cmit2
UNION ALL
SELECT elm_objid, user_objid, id_number, due_date, first_name, first_name, last_name, last_name, description, condition, owner_objid, parent_objid, '1' as type
FROM table_subc_cmit2)