Skip to Content
0
Former Member
Jun 04, 2009 at 03:36 PM

How to get SQL statements into SE16

212 Views

Does anyone know if there is a way in SE16 to get several records for a single Objid? I do not know the objid but I do know the objid has two records with one having a field1 value of 0001 and the other 0002. I want to return both records

This is what the SQL would look like but I'm not sure how I would do in SE16?

Select * from hrp5122

where posting_channel = 0001

and posting_channel = 0002

Thanks!