TABLE_(a)
    INT_    (id) PRIMARY_KEY AUTO_INCREMENT
    INT_ (mydate)
END_TABLE
 
TABLE_(b)
    INT     (id) PRIMARY_KEY AUTO_INCREMENT
    INT_    (fk_A) REFERENCES (a)
    STRING_ (mytext, 35) 
END_TABLE

#include <Core/Core.h>
#include <plugin/sqlite3/Sqlite3.h>

using namespace Upp;

#define SCHEMADIALECT <plugin/sqlite3/Sqlite3Schema.h>
#define MODEL <sqliteTest/ailien.sch>
#include "Sql/sch_header.h"
 
 
CONSOLE_APP_MAIN
{
    Sqlite3Session sqlite3;
    if(!sqlite3.Open(ConfigFile("ailien.db3"))) {
        Cout() << "Can't create or open database file\n";
        return;
    }
    
#ifdef _DEBUG
    sqlite3.SetTrace();
#endif

SqlId a("a"), b("b"), fk_A("fk_A"), mydate("mydate"), id("id"), mytext("mytext");
 
    Sql sql(sqlite3);
 Select(id.Of(a), mytext.Of(b))
.From(a)
.InnerJoin(b)
.On(id.Of(a) == fk_A.Of(b))
.Where(id.Of(a) == 2);
    while(sql.Fetch())
        Cout() << sql[0] << ' ' << sql[1] <<'\n'  ;
    
    //Error: Schema join not found ,a,       b (if I used a reference join syntax instead of plain old join)
}

select a.id, b.mytext from a join b
where a.id ==2;