trying to run PSQUERY against table that has OPRID in it and getting odd results
When I run a query against a table that has OPRID as a column, it is adding this to the query criteria, which in turn only gives me one row of data.
The Table has
ORG_NAME NOT NULL VARCHAR2(30)
OPRID NOT NULL VARCHAR2(30)
EMPLID NOT NULL VARCHAR2(11)
when I add this record to a query, it adds the criteria "where OPRID = 'myoprid'
so I am getting only one row. I need to get all rows from this table, and am not understanding what is causing this to happen.
There is no security record tied to this table.