SQL UNION returns no results

Hello,

I have a table with an alphabetical listing of one of my flexinode types. It looks great. I hand-coded it because the Views module did not correctly display my custom fields.

I have just introduced a new flexinode type that is related to the first, and need my alphabetical listing to show both flexinodes in the table.

Essentially I want a UNION of the two results, sorted alphabetically, but my union returns no results

This is my union SQL:

(SELECT DISTINCT(n.nid), n.title , flexinode_1.textual_data AS flexinode_1, flexinode_19.textual_data AS flexinode_19 FROM {node} n INNER JOIN {term_node} td USING(nid) LEFT JOIN {flexinode_data} flexinode_1 ON n.nid = flexinode_1.nid LEFT JOIN {flexinode_data} flexinode_19 ON n.nid = flexinode_19.nid WHERE n.status = 1 AND n.type = 'flexinode-1' AND flexinode_1.field_id = 1 AND flexinode_19.field_id = 19) 
UNION 
(SELECT DISTINCT(n.nid), n.title , flexinode_60.textual_data AS flexinode_60, flexinode_63.textual_data AS flexinode_63 FROM {node} n INNER JOIN {term_node} td USING(nid) LEFT JOIN {flexinode_data} flexinode_60 ON n.nid = flexinode_60.nid LEFT JOIN {flexinode_data} flexinode_63 ON n.nid = flexinode_63.nid WHERE n.status = 1 AND n.type = 'flexinode-11' AND flexinode_60.field_id = 60 AND flexinode_63.field_id = 63)

The individual queries return the correct results, but the union returns zip.

I'm not that familiar with MySQL, but from the docs, I can't figure out what I've done wrong.

Any suggestions would be greatly appreciated.

Thanks,
Tys