[Vtigercrm-developers] MySQL query

[John Crisp]

On 11/11/14 00:04, Joe Bordes wrote:
> ---------------------
> Ahhhh. I think it might be that the productcategory table is a picklist
> table, and therefore not related to anything else 
> 
> Would that be right ?
> 
> ---------------------
> 
> Yes! That is correct (more or less). That is why I said that the
> productcategoryid is rather useless and didn't know what you needed it


Thanks for the confirmation.... Yes, it finally dawned on me. I don't
understand why they aren't related. Silly really.

It had been easy with the product IDs........... thought it might be as
easy with Categories but obviously not !


> NOTE: please review that SQL carefully, I just threw that together and
> it seemed to get the correct values....

LOL :-) Your throwing it together is a lot better than mine - I'll test
to destruction in the morning !

> 
> Hope that helps

I'm sure it will. However, my midnight oil is running low and I need
some shuteye :-)

Many thanks Joe.

B. Rgds
John

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 473 bytes
Desc: OpenPGP digital signature
URL: <http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20141111/971bc7dc/attachment.pgp>