SQL newbie statement

chiragpatel_1

Hi I have 

I'm just trying to pull data after 2022 (last statement) but it's not working, I have tried placing year in front and everything but dosent work. Any suggestions on what is needed to correct this.

Im using the below data dictionary 

Thank you

ChrisTX

What is the data type for opord.kco and opgohead.kdate?   Numeric, so they don't need quotes?

Temporarily remove all text after "from HIRE.PHB.opord", and test the SQL.  Does is work OK?  Then add back each Inner Join and Where line, one at a time.

Chris