General discussion

Locked

sql Problem in delphi

By dsd2639 ·
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 .

This conversation is currently closed to new comments.

3 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

sql Problem in delphi

by 20 + years In reply to sql Problem in delphi

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;

Collapse -

sql Problem in delphi

by dsd2639 In reply to sql Problem in delphi

Poster rated this answer

Collapse -

sql Problem in delphi

by dsd2639 In reply to sql Problem in delphi

This question was closed by the author

Back to Web Development Forum
3 total posts (Page 1 of 1)  

Related Discussions

Related Forums