[ic] How to join tables with the [query] tag
Donal H.
interchange-users@interchange.redhat.com
Thu Sep 20 13:33:01 2001
> > 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'
I think there was a missing "and" at the end of that line in your original
message.
-Donal