Another SQL ?

select distinct g.gid, g.ord, p.saleprice, p.clearsale, p.name, p.prodid,
p.id, p.price, g.pid
from products p
inner join groups g on p.id = g.pid
inner join pcat pc on g.gid = pc.gid
left join description d on p.id = d.pid
where pc.gid = 'mmcolparam'
order g.ord
-------------------
*****left join description d on p.id = d.pid*****

whenever try add d.paragraph, column in d table,
an error. take out , error goes away. otherwise,
results need.

the error below.

" text, ntext, or image data type cannot selected distinct"

"lee" <lfairban_nospam@amep.com> wrote in message
news:e4fdi8$aee$1@forums.macromedia.com...

> " text, ntext, or image data type cannot selected distinct"


that error means says. you're using select distinct. if
you use text, ntext, or image column in query, can't use
distinct. data types blob (binary large object) types , not
part of row. because of that, there lot more restrictions on how
and when can used.

if product descriptions under 8000 characters, switch
varchar(8000) data type. if longer that, you'll have
to re-write query distinct not necessary.

More discussions in Dreamweaver support forum

adobe