Hi there!

Could anyone of you please tell what is wrong with the Syntax of the following query?

FROM ConfigLocalValue configLocalValue INNER JOIN
ConfigValue configValue on configLocalValue.configValue.valueID=configValue.valueID

INNER JOIN ConfigValueCategory configValueCategory ON

configValueCategory.metaID=configValue.configValueCategory.metaID

AND configValueCategory.metaID=12

AND configLocalValue.languageID =1


(It seems to be a general syntax problem, so the mappings are not that important I think)

Thanks in advance!

Toby

I don't think you need the following

on configLocalValue.configValue.valueID=configValue.valueID
ON onfigValueCategory.metaID=configValue.configValueCategory.metaID

The mapping file specifies what they are joined on I think...

So something more like:

FROM ConfigLocalValue configLocalValue
INNER JOIN configLocalValue.configValue configValue
INNER JOIN configValue.configValueCategory configValueCategory
WHERE configValueCategory.metaID=12
AND configLocalValue.languageID =1

Thanks!

So this maps localized values to "values"

From ConfigLocalValue configLocalValue
INNER JOIN configLocalValue.configValue configValue
INNER JOIN configValue.configValue.configValueCategory configValueCategory


and that links Users to Values using the UserValues mappting table.

From UserValue userValue
INNER JOIN userValue.user user
INNER JOIN userValue.configValue configValue
INNER JOIN configValue.configValue.configValueCategory configValueCategory


If I want to join now all localized values to User how would I do that?

From ConfigLocalValue configLocalValue
INNER JOIN configLocalValue.configValue configValue
INNER JOIN configValue.configValue.configValueCategory configValueCategory,

???

JOIN UserValue userValue
INNER JOIN userValue.user user
INNER JOIN userValue.configValue configValue
INNER JOIN configValue.configValue.configValueCategory configValueCategory

Like that?

Looks reasonable, it's hard to say from the info given though.

Have a good read of chapter 14.3 of the manual. It'll teach you how to do build it up and is only 1 page long.

If that solution above worked, do I get my first credit ;o)