logo
Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error

Options
Go to last post Go to first unread
j.torres@tewis.com  
#1 Posted : Friday, May 17, 2019 10:06:21 AM(UTC)
j.torres@tewis.com

Rank: Member

Groups: Registered
Joined: 4/7/2019(UTC)
Posts: 24
Man
Spain

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.
epf  
#2 Posted : Monday, May 20, 2019 6:10:00 AM(UTC)
epf

Rank: Administration

Groups: Administrators
Joined: 12/20/2013(UTC)
Posts: 930
Switzerland

Thanks: 14 times
Was thanked: 156 time(s) in 150 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...
Users browsing this topic
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.