General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Indexing and sorting
Hi -
I have another one that I would like to resolve the most effecient way.
I have 2 tables:
Table 1 has x fields: one of the fields being trannumber
Table 2 has 3 number of fields: trannumber , sort_order , details
Table 2 has an index on trannumber
Table 1 is the parent, table 2 is the child
Table 2 is related to table 1
I would like to set up a relationship between table1 and table2 whereby table 2 is sorted by the field sort_order. The problem I am having, is the key-relationship to perform the parent/child is on trannumber.
FYI: Both these tables can be extremely large.
PLease can someone advise?
Thanks,
Larry
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only