Inter-table correlation query method and device
2014
The invention provides an inter-table correlation query method and device. The inter-table correlation query method and device can shorten the time of inter-table correlation query and increase the speed of inter-table correlation query. The method includes the steps that query indicating information is obtained, the query indicating information carries a first query condition, and instruction is conducted, so that a first query result is obtained from N tables according to the first query condition; the Mth corresponding relation between the Mth table and the (M+1)th table is established according to the correlation relation between the major key value of the Mth table in the N tables and the foreign key value of the (M+1)th table; the first query result is obtained according to the selection conditions in all the N tables in the first query condition and the number of times of the Mth identification corresponding to the (M+1)th identification in the Mth corresponding relation. The inter-table correlation query method and device are suitable for the field of computers.
- Correction
- Source
- Cite
- Save
- Machine Reading By IdeaReader
0
References
0
Citations
NaN
KQI