In this project, i've try to join 2 tables.. It's an excuse to try these blocks:
Here's the block:
Note:
- When you select a table after the "from" label, this affects the "on" field (if you select pepole, you see people.ID,people.name,people.IDSex,people.IDJob)
- When you select a table after the "left join" label, this have an incidence in the "=" field
Here's the result:
Maybe v1.1 : adding multiple join
Maybe v1.2 : adding where functionality
Maybe v1.3 : * can be replaced by a list of fields
Maybe v1.4 : adding inner join