Delete comment from: Java67
Why my query doesn't work?
The query is:
SELECT MGHEAD.MGLINE, MGHEAD.MTRESP, MGHEAD.MTTRDT, MGHEAD.MTWHLO, MGHEAD.MTTRNR, MGHEAD.MTTRSH
FROM MVXBE.MVXCDTMESP.MGHEAD
WHERE (MGHEAD.MGLINE ='100') AND (MGHEAD.MTWHLO='R31') AND (MGHEAD.MTTRSH='15')
When I run, I have an error: Column MTTRSH not in table MGHEAD in MVXCDTMESP
Can you help me?
Nov 25, 2015, 7:52:21 AM
Posted to Top 10 Frequently asked SQL Query Interview Questions Answers