Hi, how i can create a view based in join two tables?. For example, my SQL is:
FROM CLIENTS A, TYPES B
WHERE A.ID=B.ID AND B.TYPE=2
Hi, in view definition use method setRelations for example:
the syntax of method setFrom is: <Alias1>:<Type1>@<PackageName>.<Name1>; ... ;<AliasN>:<TypeN>@<PackageName>.<NameN>
<Alias> is logic name <Type> is table or view <PackageName>.<Name> is full name of table or view
the syntax of method setRelations is: <TypeRel1>:<AliasRel1_1>.<ColRel1_1>=<AliasRel1_2>.<ColRel1_2>&& ... ; ....
<TypeRel> is relation type:
> left join
< right join
- inner join
the syntax of method setColumns is: <AliasCol1>:<Expression1> ; ... ; <AliasColN>:<ExpressionN>
Ok, thanks for your help, anyway I continue seeing the application, it seems to me to be interesting enough.
sorry i have forget B.TYPE=2:
Sign up for the SourceForge newsletter:
You seem to have CSS turned off.
Please don't fill out this field.