Technically, I don't see anything wrong. Check your script, maybe the same field "cred" exists in another table not showing in the script above.
Logically, not sure why you're loading this, it just creates one field with one value. If you really need it for so"me reason, you could've used
'APRN' as cred
Logically, not sure why you're loading this, it just creates one field with one value.
It is a standard practice of respect we give to all of our medical providers. While yes, the report will only show APRNs and there will only be one field value of 'APRN', they still deserve to have the distinction of their earned credentials appear next to their names.
Thank you for your alternate script, unfortunately I am still getting the same results.
The where condition which you had written is above the SQL part. Its called as preceding load. You need to write the where condition after SQL part
From "DB name"."owner name"."Table Name"
where Field2 = 'APRN';