Re: Joint Between two tables

[Warren Young]

Mandy Llanes wrote:
> With de Structs create by sql_create_n(................) i cant insert 
> operate. But when i need JOINT Between two table.....ex. SELECT t1.f1, 
> t2.f3 FROM t1, t2 WHERE t1.f2=t2.f2 ....
> how create dinamic the struct? any truck & trips?

An SSQLS doesn't necessarily have to mirror the structure of a table. 
You can create one with the same field set as your JOIN query.  The only 
restriction is that the SSQLS must declare its fields in the same order 
as the query results.