Thread zuviele JOINs für mySQL (6 answers)
Opened by Ronnie at 2005-05-27 19:50

renee
 2005-05-30 01:36
#33312 #33312
User since
2003-08-04
14371 Artikel
ModeratorIn
[Homepage] [default_avatar]
Benutzt man dafür nicht OUTER JOIN??

Warum machst Du den Code eigentlich so umständlich??

Code: (dl )
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
my %sql = ('experience.country' =>  q#JOIN has_regional_experience ON people.ID_person = has_regional_experience.ID_person
JOIN countries AS experience ON has_regional_experience.ID_country = experience.ID_country
#,
'nationality.country' => q#JOIN belongs_to ON people.ID_person = belongs_to.ID_person
JOIN countries AS nationality ON belongs_to.ID_country = nationality.ID_country
#,
'expertise' => q#JOIN owns ON people.ID_person = owns.ID_person
JOIN expertise ON owns.ID_expertise = expertise.ID_expertise
#,
'language' => q#JOIN spoke ON people.ID_person = spoke.ID_person
JOIN languages ON spoke.ID_language = languages.ID_language
#,
'donor' => q# JOIN worked_for ON people.ID_person = worked_for.ID_person
JOIN donors ON worked_for.ID_donor = donors.ID_donor
#);

$sqlquery .= $sql{$self->{field1}}.$sql{$self->{field2}}.$sql{$self->{field3}}

ungetestet!
OTRS-Erweiterungen (http://feature-addons.de/)
Frankfurt Perlmongers (http://frankfurt.pm/)
--

Unterlagen OTRS-Workshop 2012: http://otrs.perl-services.de/workshop.html
Perl-Entwicklung: http://perl-services.de/

View full thread zuviele JOINs für mySQL