[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
_/ _/ _/_/_/_/ _/ _/_/_/ _/ _/