[odb-users] Defining a table view with inner join
liorta at gmail.com
Fri Jan 19 06:36:52 EST 2018
Suppose I have 2 database tables:
CREATE TABLE developers(
CREATE TABLE new_employees(
I wish to define a table view that contains all the *new developers*.
With simple SQL query this can be achieved easily by using inner join:
"select * from developers inner join new_employees on
developers.employee_id == new_employees.id"
What's the best way to achieve this with table view pragma?
#pragma db view table("developers" ...) // not sure how to continue this
#pragma db column("employee_name") type("TEXT")
More information about the odb-users