multi join rule in multi db loader
Hi all,
I am trying to employ the following query:
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!
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😉
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! 😀
This topic is locked and no more replies can be posted.