Re: Need help writing query

I loaded MySQL 4.1, but now the text is gibberish in the Group_Concat field SELECT Cat_Item_Img,Cat_Price,Product.Item_Code,GROUP_CONCAT(Item_Size SEPARATOR ";") as sizes,Item_Img, Description,Category,Retail_Price,Short_Desc,Product.Item_Color FROM Cat_Items,Product WHERE cat_code ="BoltTech" an

Re: Need help writing query

Patrick Shoaf <[EMAIL PROTECTED]> wrote: > I have a table name product defined as follows: > Item_Code > Item_Size > Item_Color > Item_img > Description > Cost > Retail_Price > Category > and other non-essential items, such as qty based on code,size,&color > > The data is as follows: > j2400 S

Need help writing query

I have a table name product defined as follows: Item_Code Item_Size Item_Color Item_img Description Cost Retail_Price Category and other non-essential items, such as qty based on code,size,&color The data is as follows: j2400 S BLK j2400blk.jpgBlack Jacket12.00 24.00 Jacket