To generate a SELECT DISTINCT (cursor) statement
 
   
   
	  
		- Start the OpenESQL Assistant. 
		
 
 
		- Connect to the data source. 
		
 
 
		- Check the box next to a table name. 
		
 
 
		- Click 
		  SELECT DISTINCT (cursor), then click 
		  OK. 
		
 
 
		- Check the box next to each column you want to include in the SELECT statement. 
		
 
 
		- Further define the query using the 
		  Search Criteria and 
		  Sort features. Optional.