Forums

multi join rule in multi db loader

chrissy6930 10 Mar, 2014
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!
chrissy6930 10 Mar, 2014
ohhh! that automated reply solved my prob!! yay! 😀
This topic is locked and no more replies can be posted.

VPS & Email Hosting 20% discount
hostinger