[Date Prev][Date Next][Thread Prev][Thread Next][Interchange by date
][Interchange by thread
]
RE: [ic] How to join tables with the [query] tag
>
> 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.
_______________________________________________
interchange-users mailing list
interchange-users@interchange.redhat.com
http://interchange.redhat.com/mailman/listinfo/interchange-users