List:MySQL++« Previous MessageNext Message »
From:Warren Young Date:September 12 2007 9:48pm
Subject:Re: Joint Between two tables
View as plain text  
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.
Joint Between two tablesMandy Llanes12 Sep
  • Re: Joint Between two tablesWarren Young12 Sep