Select(ID(ID, NAME, LASTNAME))
.From(TABLE1).LeftJoinRef(TABLE2)
.Where(BDATE == Date(2011, 12, 9))

select ID.ID, ID.NAME, ID.LASTNAME
 from TABLE1 left outer join TABLE2 on TABLE2.TABLE1_ID = TABLE1.NAME
 where BDATE = date '2011-12-09'

Select(ID(ID, NAME, LASTNAME))
.From(TABLE1).LeftJoinRef(TABLE2).On(IsNull(BDATE))
.Where(BDATE == Date(2011, 12, 9))

select ID.ID, ID.NAME, ID.LASTNAME
 from TABLE1 left outer join TABLE2 on TABLE2.TABLE1_ID = TABLE1.NAME and BDATE is NULL
 where BDATE = date '2011-12-09'

TABLE_(TABLE_B)
	INT_    (B_ID) PRIMARY_KEY AUTO_INCREMENT
	INT_    (AGE)
END_TABLE

TABLE_(TABLE_C)
	INT_    (C_ID) PRIMARY_KEY AUTO_INCREMENT
	INT_    (WEIGTH)
END_TABLE

TABLE_(TABLE_A)
	INT_    (A_ID) PRIMARY_KEY AUTO_INCREMENT
	INT_    (A_REF_B) REFERENCES(TABLE_B)
	INT_    (A_REF_C) REFERENCES(TABLE_C)
	INT_    (A_SIZE)
END_TABLE

Sql * Select(myData).From(TABLE_A)
      .LeftJoinRef(TABLE_B).Where(AGE == xxxx)
      .LeftJoinRef(TABLE_C).Where(WEIGHT == yyyy)

Sql * Select(myData).From(TABLE_A)
      .LeftJoinRef(TABLE_B).On(AGE == xxxx)
      .LeftJoinRef(TABLE_C).On(WEIGHT == yyyy)

Sql * Select(myData).From(TABLE_A)
      .Where(    A_REF_B == Select(B_ID).From(TABLE_B).Where(AGE == xxxxxx) 
              && A_REF_C == yyyyyyy
            );

TABLE_(TABLE_B)
	INT_    (B_ID) PRIMARY_KEY AUTO_INCREMENT
	INT_    (AGE)
END_TABLE

TABLE_(TABLE_C)
	INT_    (C_ID) PRIMARY_KEY AUTO_INCREMENT
	INT_    (WEIGTH)
END_TABLE

TABLE_(TABLE_A)
	INT_    (A_ID) PRIMARY_KEY AUTO_INCREMENT
	INT_    (A_REF_B) REFERENCES(TABLE_B)
	INT_    (A_REF_C) REFERENCES(TABLE_C)
	INT_    (A_SIZE)
END_TABLE

Select(myData.Of(TABLE_A)).From(TABLE_A)
.InnerJoinRef(TABLE_B).On(AGE.Of(TABLE_B) == xxxxxx).Where(A_REF_C.Of(TABLE_A) == yyyyyy);