A straightforward a couple desk ask computes these types of show even when the sized brand new numeric range commonly similar. Within this example, we play with two tables (Age groups and Customers), and something query (Frequency: Many years Shipment). Merely follow these simple actions:
Simply carry out a dining table with four areas: Classification ID (counter), Class Name (text), Minimal (number), and Limit (number). For each listing, explain the brand new teams and its own reasonable and you will high viewpoints:
See how [Maximum] property value you to checklist are smaller compared to the new [Minimum] value of another listing. They can not become the same otherwise such thinking do end up in one or two groups. Inside our example, this analysis is integers therefore playing with integers in this desk is okay. If you don’t, you are able to numbers really near to both (age.g. 999). You could term and you can indicate as much communities as you like.
2: Would multiple-desk See query
Note that both dining tables packages aren’t associated with for each and every other. (далее…)