From: Warren Young
Date: September 12 2007 9:48pm
Subject: Re: Joint Between two tables
List-Archive: http://lists.mysql.com/plusplus/7001
Message-Id: <46E85EA3.7040001@etr-usa.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

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.