[ic] How to join tables with the [query] tag
Stefan Hornburg Racke
interchange-users@interchange.redhat.com
Thu Sep 20 13:09:00 2001
"Javier Martin" <martin@trymedia.com> writes:
[...]
> >
> > Query was:
> > select transactions.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
Here are quotes missing. Use:
orderline.sku = '00dc9066f52ad31184eb0080c70ea797'
> > transactions.deleted != '1'
> > order by affiliate, campaign, order_date
> >
I would use:
select T.affiliate, ..., O.order_number, ...
from transactions T, orderline O
where ...
What database you are using ?
Ciao
Racke
--
Racke happily hacks Interchange and maintains Debian packages like Courier.
For projects and other business stuff please refer to COBOLT NetServices
(URL: http://www.cobolt.net; Email: info@cobolt.net; Phone: 0041-1-3884400)