Forums

Hi all,

I am trying to employ the following query:

SELECT `Manage_Horses`.*, `Coats`.`cf_id` AS `Coats.cf_id`, `Coats`.`name` AS `Coats.name`, `Eyes`.`cf_id` AS `Eyes.cf_id`, `Eyes`.`name` AS `Eyes.name`
FROM `#__cf_horses` AS `Manage_Horses`
INNER JOIN `#__cf_coats` AS `Coats` ON Manage_Horses.coat = Coats.cf_id
INNER JOIN `#__cf_eyes` AS `Eyes` ON Manage_Horses.eye = Eyes.cf_id
ORDER BY Manage_Horses.name

but I do not get it to work (error 1064)

main multi record loader
table:#__cf_horses
model ID:Manage_Horses
Load Data:yes
Enable Associations:yes
JOIN Type:INNER
Associated Models:Coats,Eyes
WHERE statement:
Manage_Horses.coat= Coats.cf_id,
Manage_Horses.eye= Eyes.cf_id
ORDER BY Manage_Horses.name

auxiliary multi record loader1
table:#__cf_coats
model ID:Coats
Fields:cf_id,name
Load Data:no
Enable Associations:no

auxiliary multi record loader2
table:#__cf_eyes
model ID:Eyes
Fields:cf_id,name
Load Data:no
Enable Associations:no

could u pls help me out?

best regards!

Hello chrissy6930,
I'm not a Chrono professional, but after checking your new post, I think that the following links may help:
How can I link two DB Multi Record Loaders?
P.S: I'm just an automated service😉

...and a form backup

ohhh! that automated reply solved my prob!! yay! 😀