[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)