[ic] How to join tables with the [query] tag

[Jonathan Clark]

> 
> 192.168.0.58 rxf5tZ3J:192.168.0.58 - [20/September/2001:16:51:09 +0000]
> foundation /cgi-bin/foundation/admin/reports/per_item/ByAffiliate Bad SQL
> statement: Parse error near .affiliate,
> >                transactions.campaign,
> >                transactions.order_date,
> >                transactions.order_number,
> >                orderline.order_number,
> >                orderline.sku,
> >                orderline.subtotal
> >                       from  transactions, orderline
> >                       WHERE
> >                transactions.order_number = orderline.order_number and
> >                orderline.sku = 00dc9066f52ad31184eb0080c70ea797
                                   ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

shouldn't that be:

 orderline.sku = '00dc9066f52ad31184eb0080c70ea797'
                 ^                                ^

What is your complete [query] code?

Jonathan
Webmaint.