Drupal: 'Views2 Returns Zero Results but SQL Is Fine!' Problem

This has happened couple times, already, so I may as well blog about it. If you use Views in Drupal, you already know that it shows you the final SQL generated. Very useful feature, but there's a rare edge condition when the SQL returns results (if you run it from an SQL client), but Views shows zero elements. Extremely frustrating and confusing.

How can this happen?

Drupal: Expose a Custom Field to Views2

Here is a quick introductory tutorial exposing columns in custom tables as fields in Views2. Sometimes you need to store auxiliary data outside the nodes/CCK tables, but you still want to allow Views to handle the data. Here's how to do that.

The Views2 Attachment Display

With Drupal5 and Views, theming was very straight forward: just add a specifically named function and there you go. Views2 changes all of that, and that is frustrating at first.