sql Problem in delphi

I have many table and use in delphi
program . I want join 2 table by on field
and i want keep first table seq .
But if run quey the result order by first table first index key .
thank .