SQL newbie statement
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
chiragpatel_1
8 - Asteroid
‎08-12-2022
02:44 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
1 REPLY 1
16 - Nebula
‎08-12-2022
04:32 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
