SQL Query error with Join

Question

When I try to execute this SQL query, I get an error and I don't know how to correct it

select  * 
from    pg_specialites_annees   pgs  
where   pgs.NOM_FR like '%tets%' 
left join pg_specialites_parametres pgsp on pgsp.ID_SPECIALITE = pgs.ID_SPECIALITE;

When I remove the LIKE it works, but I need a specific row.

Please help me, I don't know how to do it. I want to show some details for a specific row in table from another table.

SQL expects statements to be in the following order: SELECT, FROM, JOIN, ON, WHERE, GROUP BY, HAVING, ORDER BY which is not the same order as execution. — xQbert
– xQbert, Commented Dec 22, 2015 at 13:58
The complete and correct syntax for a select statement is documented in the manual of your DBMS. — user330315
– user330315, Commented Dec 22, 2015 at 14:33

Siyual · Accepted Answer · 2015-12-22 13:56:27Z

1

Your LEFT JOIN needs to come before the WHERE:

Select      * 
From        pg_specialites_annees       pgs  
Left Join   pg_specialites_parametres   pgsp    on  pgsp.ID_SPECIALITE = pgs.ID_SPECIALITE
Where       pgs.NOM_FR Like '%tets%';

answered Dec 22, 2015 at 13:56

Siyual

17k8 gold badges47 silver badges60 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Arnaud · Accepted Answer · 2015-12-22 13:56:21Z

1

Put your where clause after the join clause :

select * from pg_specialites_annees pgs  
        left join pg_specialites_parametres pgsp on pgsp.ID_SPECIALITE = pgs.ID_SPECIALITE;
        where  pgs.NOM_FR like '%tets%'

answered Dec 22, 2015 at 13:56

Arnaud

17.6k3 gold badges34 silver badges46 bronze badges

Collectives™ on Stack Overflow

SQL Query error with Join

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related