1

Topic: Sampling of record with a ceiling price

There are three tables, it is required to fulfill request:
To display the record containing fields: No a section, the section Area, the State with a ceiling price.
Data from all tables is used, therefore I unite them:

select B. ` No ordinal `, B. ` the section Area `, B. ` the State ` from ` Sections ` as B inner join (` Standard projects of structures ` as A inner join ` Structures on sections ` as a C on A. ` No the project ` =C. ` No the project `)
on B. ` No ordinal ` =C. ` No ordinal`

And here is how to deduce a section with . The price I do not understand.