Web Development

Ask something
Discussion Locked

sql Problem in delphi

0 helpful
3 replies

by dsd2639

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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 .

3 replies

by 20 + years

This should help as an example. You can use the order by clause to sort to your desired column. Pretend that date is the first tables seq and that field is your join column.

Select date
from table1 a, table2 b
where a.field = b.field
order by date;

This discussion is closed to new replies.