Je suis au niveau 3 avec subjects5
Je dois chercher Textes archaïques dans subject_fr
Cherchons le type de subject_fr
requête : SELECT t.typcategory FROM pg_attribute a JOIN pg_type t ON t.oid = a.atttypid JOIN pg_class c ON c.oid = a.attrelid JOIN pg_namespace n ON n.oid = c.relnamespace WHERE c.relname = 'subjects' AND a.attname = 'subject_fr' AND a.attnum > 0 AND n.nspname = 'public'subject_fr vaut : S
Je dois chercher Textes archaïques dans subject_en
Cherchons le type de subject_en
requête : SELECT t.typcategory FROM pg_attribute a JOIN pg_type t ON t.oid = a.atttypid JOIN pg_class c ON c.oid = a.attrelid JOIN pg_namespace n ON n.oid = c.relnamespace WHERE c.relname = 'subjects' AND a.attname = 'subject_en' AND a.attnum > 0 AND n.nspname = 'public'subject_en vaut : S
Je dois chercher Textes archaïques dans subject_fr
Cherchons le type de subject_fr
requête : SELECT t.typcategory FROM pg_attribute a JOIN pg_type t ON t.oid = a.atttypid JOIN pg_class c ON c.oid = a.attrelid JOIN pg_namespace n ON n.oid = c.relnamespace WHERE c.relname = 'subjects' AND a.attname = 'subject_fr' AND a.attnum > 0 AND n.nspname = 'public'subject_fr vaut : S
Je dois chercher Textes archaïques dans subject_en
Cherchons le type de subject_en
requête : SELECT t.typcategory FROM pg_attribute a JOIN pg_type t ON t.oid = a.atttypid JOIN pg_class c ON c.oid = a.attrelid JOIN pg_namespace n ON n.oid = c.relnamespace WHERE c.relname = 'subjects' AND a.attname = 'subject_en' AND a.attnum > 0 AND n.nspname = 'public'subject_en vaut : S
Erreur SQL tout2 :
SELECT * from biblio LEFT JOIN biblio_subjects ON (biblio_subjects.id_biblio=biblio.id_biblio) LEFT JOIN subjects ON (subjects5.id_subject=biblio_subjects.id_subject) WHERE biblio.id_biblio = 16659
ERROR: missing FROM-clause entry for table "subjects5" LINE 1: ...iblio=biblio.id_biblio) LEFT JOIN subjects ON (subjects5.... ^