[ic] sql inner join problems

Kevin Walsh interchange-users@interchange.redhat.com
Wed Jun 5 19:18:01 2002


> <table>
> [query type="html" sql=|
>     SELECT  m.sku, p.description
>     FROM    products p, merchandising m
>     WHERE   p.sku = m.sku
> ]][/query]
> </table>
> 
Spotted just as posted that message, the query should be like this,
of course:

    <table>
    [query type="html" sql=|
        SELECT  m.sku, p.description
        FROM    products p, merchandising m
        WHERE   p.sku = m.sku
    |][/query]
    </table>

Oops.

-- 
   _/   _/  _/_/_/_/  _/    _/  _/_/_/  _/    _/
  _/_/_/   _/_/      _/    _/    _/    _/_/  _/   K e v i n   W a l s h
 _/ _/    _/          _/ _/     _/    _/  _/_/    kevin@cursor.biz
_/   _/  _/_/_/_/      _/    _/_/_/  _/    _/