Je suis au niveau 3 avec periods4
Je dois chercher Premières dynasties dans period_fr
Cherchons le type de period_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 = 'periods4' AND a.attname = 'period_fr' AND a.attnum > 0 AND n.nspname = 'public'Je dois chercher Premières dynasties dans period_en
Cherchons le type de period_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 = 'periods4' AND a.attname = 'period_en' AND a.attnum > 0 AND n.nspname = 'public'Je dois chercher Premières dynasties dans period_fr
Cherchons le type de period_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 = 'periods4' AND a.attname = 'period_fr' AND a.attnum > 0 AND n.nspname = 'public'Je dois chercher Premières dynasties dans period_en
Cherchons le type de period_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 = 'periods4' AND a.attname = 'period_en' AND a.attnum > 0 AND n.nspname = 'public'Erreur SQL tout2 :
SELECT * from biblio LEFT JOIN biblio_periods ON (biblio_periods.id_biblio=biblio.id_biblio) LEFT JOIN periods periodsON (periods4.id_period=biblio_periods.id_period) WHERE biblio.id_biblio = 10109
ERROR: syntax error at or near "." LINE 1: ...id_biblio) LEFT JOIN periods periodsON (periods4.id_period... ^