Displaying Line Item Fields in a View (SQL Error)
I was running into the same problem too. You have to create the relationship "Commerce Line Item: Order ID" and display the field "Commerce Order: Order ID" to get around the mysql error.

You can get the view by importing the following code:

    $view = new view();
    $view-&gt;name = 'commerce_line_items';
    $view-&gt;description = '';
    $view-&gt;tag = 'default';
    $view-&gt;base_table = 'commerce_line_item';
    $view-&gt;human_name = 'Commerce Line Items';
    $view-&gt;core = 7;
    $view-&gt;api_version = '3.0';
    $view-&gt;disabled = FALSE; /* Edit this to true to make a default view disabled initially */

    /* Display: Master */
    $handler = $view-&gt;new_display('default', 'Master', 'default');
    $handler-&gt;display-&gt;display_options['title'] = 'Commerce Line Items';
    $handler-&gt;display-&gt;display_options['use_more_always'] = FALSE;
    $handler-&gt;display-&gt;display_options['access']['type'] = 'none';
    $handler-&gt;display-&gt;display_options['cache']['type'] = 'none';
    $handler-&gt;display-&gt;display_options['query']['type'] = 'views_query';
    $handler-&gt;display-&gt;display_options['exposed_form']['type'] = 'basic';
    $handler-&gt;display-&gt;display_options['pager']['type'] = 'full';
    $handler-&gt;display-&gt;display_options['pager']['options']['items_per_page'] = '10';
    $handler-&gt;display-&gt;display_options['style_plugin'] = 'default';
    $handler-&gt;display-&gt;display_options['row_plugin'] = 'fields';
    /* Relationship: Commerce Line Item: Order ID */
    $handler-&gt;display-&gt;display_options['relationships']['order_id']['id'] = 'order_id';
    $handler-&gt;display-&gt;display_options['relationships']['order_id']['table'] = 'commerce_line_item';
    $handler-&gt;display-&gt;display_options['relationships']['order_id']['field'] = 'order_id';
    /* Field: Commerce Line Item: Line item ID */
    $handler-&gt;display-&gt;display_options['fields']['line_item_id']['id'] = 'line_item_id';
    $handler-&gt;display-&gt;display_options['fields']['line_item_id']['table'] = 'commerce_line_item';
    $handler-&gt;display-&gt;display_options['fields']['line_item_id']['field'] = 'line_item_id';
    /* Field: Commerce Order: Order ID */
    $handler-&gt;display-&gt;display_options['fields']['order_id_1']['id'] = 'order_id_1';
    $handler-&gt;display-&gt;display_options['fields']['order_id_1']['table'] = 'commerce_order';
    $handler-&gt;display-&gt;display_options['fields']['order_id_1']['field'] = 'order_id';
    $handler-&gt;display-&gt;display_options['fields']['order_id_1']['relationship'] = 'order_id';
    $handler-&gt;display-&gt;display_options['fields']['order_id_1']['link_to_order'] = 'customer';