Re: [development] Crossing information between content types

The CCK developera re always one step ahead. They have some helpful functions for building joins that will work even if a field changes its multiple status or you do an upgrade. Here is an example "safe" join: $field_bw = content_fields('field_blog_weight'); $db_info_bw = content_database_info($field_bw); $sql = "SELECT n.nid, n.title FROM {node} n JOIN {". $db_info_bw['table'] . '} bw ON n.vid=bw.vid';