I have a view that displays table results (viewgrid). In order to have access to all fields in the primary table (incident) when printing, I create a very simple select command:

select incident.* ;
    from viewgrid, incident ;
    where incident.inc_id = viewgrid.inc_id ;
    into cursor printjob

I would think that printjob would retain the fields in the order of viewgrid, but this is not happening. It seems to be in the natural order of incident.

Is there something wrong with my select command? Should I be handling this differently?