Topic: The help in request writing
People knowing, help ignorant with the task decision.
For search % under the contract tables T1, T2, T3 if ID contracts is present at several tables the commission undertakes from the table with smaller number (the data in T1 more priority T2 are viewed, 2 is more priority 3). Table T4 contains numbers of all contracts and their correspondence with ID. To write the request returning numbers of contracts and value of the commissions on them.
The screen of the task with tables is attached.