Using a order by

One Star

Using a order by

I do a jointure (inner join) with many table. Before doing a Tmap to do converting, I wish to sort my data flow by an "order by".I saw it exists a TSortRow but this one doesn't accept many input. How can I sort result data flow ? Indeed, I would like to implement an example like this one :
SELECT * FROM A, B where order by;
Do you know how to implement it ?

Thnx for your help.
One Star

Re: Using a order by

your SQL does a join and a sort in one statement. You can sort your row with tSortRow after the tMap.
Will this work for you or is there any additional specialty?