create a cognos query based on native sql select

Step 1. dragging SQL object to workspace to create a query based on native sql

draw SQL object

Step 2. select the data source for the sql query

select data source

Step 3. enter teradata native sql select statement

enter teradata native sql select statement

Step 4. draw the new query to create a list report

draw the new query to create a list report

Step 5. first page of report

first page of report