cancel
Showing results for 
Search instead for 
Did you mean: 

SQL Script - error in executing the select with multiple conditions

rogerio_vazdesouza2
Participant
0 Kudos

Hi gurus,

I'm having trouble in the command syntax below:



SELECT * FROM "TEST_RVS"."VH_TEST"  WHERE   "AUFNR" = 20210807 AND  "BWART" = 101.

WHAT IS THE CORRECT SYNTAX WHERE TO CONDITION WITH MULTIPLE FIELDS?


Thanks !

Accepted Solutions (1)

Accepted Solutions (1)

RichHeilman
Developer Advocate
Developer Advocate
0 Kudos

What is the error you are getting?  Did you try wrapping the values with quotes?

SELECT * FROM "TEST_RVS"."VH_TEST"  WHERE   "AUFNR" = '20210807' AND  "BWART" = '101'.


Cheers,

Rich Heilman

rogerio_vazdesouza2
Participant
0 Kudos

Thanks Rich !

Answers (0)