[sde]

thanks djm.. i saw this last night but 2am was too late to give it a shot.

i got it working today and i get 3 rows for every one completely related record. for example

+-----+------------+------------+-------------+---------+-------+
| nid | body       | created    | title       | artist  | album |
+-----+------------+------------+-------------+---------+-------+
|  32 | test       | 1177359050 | NULL        | NULL      | NULL  |
|  32 | test       | 1177359050 | NULL        | NULL      | NULL  |
|  32 | test       | 1177359050 | mytitle      | myartist | myalbum  |

i just added 'title is not null' to the where clause and i get the set i'm looking for.

thanks.