Rank: Member
Groups: Registered
Joined: 4/7/2019(UTC) Posts: 24   Thanks: 7 times
|
Hello and thanks for this solution. We're getting great results.
I have two tables. In table 1 there are two INT fields, Year and Month. In table 2, the original one have the same fields but STRING. I've modified the definition of the columns to convert them to INT. Everithing works well. I've defined two Joins, joinMonth and JoinYear. In the model, I use one field of each table as Data Elements. The final SQL Statement is not completelly right because doens't includes the join for month. How can I fix it?
Thanks.
|
|
|
|
|
|
Rank: Administration
Groups: Administrators
Joined: 12/20/2013(UTC) Posts: 1,209  Thanks: 14 times
Was thanked: 206 time(s) in 199 post(s)
|
Your question is not clear....you can fully control the joins or even the SQL generated by modifying the 'SQL' properties in your model definition...
|
|
|
|
|
|
Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.
