[Date Prev][Date Next][Thread Prev][Thread Next][Interchange by date
][Interchange by thread
]
[ic] sql inner join problems
> <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
_/ _/ _/_/_/_/ _/ _/_/_/ _/ _/