Skip to Content
0
Former Member
Jan 11, 2012 at 03:27 PM

Query Definition

36 Views

Hi,

I am trying to write a query which returns all the master agreement names, id, date etc which are neither closed nor cancelled. I wrote the query given below. However it returned no results.

Select

<%RESULTS%>

From

<%SCHEMA%>.FCI_CONTRACT T1

Where

T1.CANCELED_AT = NULL

Please let me know where i am going wrong.

Regards,

Anshuman