JOIN = loooong execution time

Just getting my hands dirty with the ODBC stuff.  Started with a simple transaction query:

string sql = "SELECT t.create_date, t.transaction_id, t.transaction_type, t.status " +  "FROM transactions AS t " +  "WHERE t.transaction_type = 'Sales Order' AND (t.status = 'Pending Fulfillment' OR t.status = 'Pending Billing/Partially Fulfilled') " +  "ORDER BY t.create_date DESC";

This executes pretty quick, about 1.5 seconds.

I then wanted to try some joins to see how they would perform.

string sql = "SELECT e.name, t.create_date, t.transaction_id, t.transaction_type, t.status " +  "FROM transactions AS t " +  "LEFT JOIN customers AS e ON e.customer_id = t.entity_id " +  "WHERE t.transaction_type = 'Sales Order' AND (t.status = 'Pending Fulfillment' OR t.status = 'Pending Billing/Partially Fulfilled') " +  "ORDER BY t.create_date DESC";