Query ( Depeche-0.7.5 )

java.lang.Object
- java.util.AbstractCollection<E>
- - java.util.AbstractList<Record>
  - - net.aditsu.depeche.BaseQuery
    - - net.aditsu.depeche.SQLQuery
      - net.aditsu.depeche.Query

All Implemented Interfaces:

Serializable, Iterable<Record>, Collection<Record>, List<Record>, DynamicQuery, IQuery
```
public class Query
extends SQLQuery
implements DynamicQuery
```
Query with dynamic SQL building

Author:

aditsu

See Also:
Serialized Form

Method Summary

Methods
Modifier and Type	Method and Description
`Query`	`copy()` Returns a copy of this query, without any cached results
`int`	`count()` Returns the number of rows that this SELECT query would find, as an int value.
`int`	`count(Conn conn)` Returns the number of rows that this SELECT query would find, as an int value.
`int`	`delete()` Runs this query as a DELETE query and returns the number of rows
`int`	`delete(Conn conn)` Runs this query as a DELETE query using the given connection and returns the number of rows
`Query`	`desc(List<String> fields)` Adds the given fields (descending) to the list of fields to sort by, and returns a new query
`Query`	`desc(String... fields)` Adds the given fields (descending) to the list of fields to sort by, and returns a new query
`Query`	`distinct()` Adds the "DISTINCT" clause to the query, and returns a new query
`Query`	`exclude(Condition cond)` Adds the negation of a condition to this query (using "AND" with an existing condition) and returns a new query
`Query`	`exclude(KeyInfo keyInfo, Key key)` Adds a condition to NOT match a list of columns with a list of values, and returns a new query
`Query`	`exclude(SQLCondition cond)` Adds the negation of a SQL condition to this query (using "AND" with an existing condition) and returns a new query
`Query`	`exclude(String name, Serializable value)` Adds a condition that the column with the given name should NOT have the given value, and returns a new query
`Query`	`exclude(String name, String op, Serializable value)` Adds a negative "name operator value" condition and returns a new query
`Query`	`excludeIn(String name, Collection<? extends Serializable> values)` Adds a negative "name IN (values)" condition and returns a new query
`Query`	`field(String field, String alias)` Adds "field AS alias" to the list of fields to select in each record, and returns a new query
`Query`	`fields(List<String> fields)` Adds the given fields to the list of fields to select in each record, and returns a new query
`Query`	`fields(List<String> fields, List<String> aliases)` Adds the given fields with the given aliases to the list of fields to select in each record, and returns a new query
`Query`	`fields(String... fields)` Adds the given fields to the list of fields to select in each record, and returns a new query
`Query`	`filter(Condition cond)` Adds a condition to this query (using "AND" with an existing condition) and returns a new query
`Query`	`filter(KeyInfo keyInfo, Key key)` Adds a condition to match a list of columns with a list of values, and returns a new query
`Query`	`filter(Record rec, KeyInfo cols)` Adds a condition to match a list of columns with a list of corresponding values from a Record, and returns a new query
`Query`	`filter(Record rec, String... cols)` Adds a condition to match a list of columns with a list of corresponding values from a Record, and returns a new query
`Query`	`filter(SQLCondition cond)` Adds a SQL condition to this query (using "AND" with an existing condition) and returns a new query
`Query`	`filter(String name, Serializable value)` Adds a condition that the column with the given name should have the given value, and returns a new query
`Query`	`filter(String name, String op, Serializable value)` Adds a "name operator value" condition and returns a new query
`Query`	`filterIn(String name, Collection<? extends Serializable> values)` Adds a "name IN (values)" condition and returns a new query
`Query`	`filterPK(List<Serializable> values)` Adds a condition that matches the primary key columns of the query's table to the given values and returns a new query
`Query`	`filterPK(Serializable... values)` Adds a condition that matches the primary key columns of the query's table to the given values and returns a new query
`String`	`getDeleteSQL()` Returns the SQL string for running this query as a DELETE query
`String`	`getInsertSQL()` Returns the SQL string for running this query as an INSERT query
`List<Serializable>`	`getParams()` Returns this query's parameters
`String`	`getSelectSQL()` Returns the SQL string for running this query as a SELECT query
`String`	`getTable()` Returns the main table being queried
`String`	`getUpdateSQL()` Returns the SQL string for running this query as an UPDATE query
`int`	`insert()` Runs this query as an INSERT query and returns the number of rows
`int`	`insert(Conn conn)` Runs this query as an INSERT query using the given connection and returns the number of rows
`boolean`	`isLimited()` Returns true if this query has a limit or offset
`Query`	`join(Join join)` Adds the given join object to the query's joins and returns a new query
`Query`	`join(JoinType type, String table, String fld1, String fld2)` Adds a join of a given type, with a given table, with the condition that the two given fields are equal, and returns a new query; all parameters are quoted
`Query`	`join(String table, String fld1, String fld2)` Adds an inner join with a given table, with the condition that the two given fields are equal, and returns a new query; all parameters are quoted
`Query`	`joinParent(FKey fk)` Adds an inner join with a parent table, linked through the given foreign key
`Query`	`joinParent(JoinType type, FKey fk)` Adds a join of a given type, with a parent table, linked through the given foreign key
`Query`	`joinParentFrom(JoinType type, String table)` Adds a join of a given type, with the given parent table, linked through a foreign key
`Query`	`joinParentFrom(String table)` Adds an inner join with the given parent table, linked through a foreign key
`Query`	`joinParents()` Adds inner joins with all parent tables, linked through foreign keys
`Query`	`joinParents(JoinType type)` Adds joins of a given type, with all parent tables, linked through foreign keys
`Query`	`joinParentThrough(JoinType type, String column)` Adds a join of a given type, with a parent table, linked through the given column
`Query`	`joinParentThrough(String column)` Adds an inner join with a parent table, linked through the given column
`Query`	`leftJoin(String table, String fld1, String fld2)` Adds a left join with a given table, with the condition that the two given fields are equal, and returns a new query; all parameters are quoted
`Query`	`leftJoinParent(FKey fk)` Adds a left join with a parent table, linked through the given foreign key
`Query`	`leftJoinParentFrom(String table)` Adds a left join with the given parent table, linked through a foreign key
`Query`	`leftJoinParents()` Adds left joins with all parent tables, linked through foreign keys
`Query`	`leftJoinParentThrough(String column)` Adds a left join with a parent table, linked through the given column
`Query`	`limit(long x)` Limits the number of records to select and returns a new query
`Query`	`lock(RowLock rowLock)` Sets the given row lock (for SELECT) and returns a new query
`long`	`longCount()` Returns the number of rows that this SELECT query would find, as a long value.
`long`	`longCount(Conn conn)` Returns the number of rows that this SELECT query would find, as a long value.
`Query`	`offset(long x)` Sets the offset of the first record to select (i.e.
`Query`	`order(List<String> fields)` Adds the given fields (ascending) to the list of fields to sort by, and returns a new query
`Query`	`order(String... fields)` Adds the given fields (ascending) to the list of fields to sort by, and returns a new query
`Query`	`rawFields(String... fields)` Adds the given raw SQL expressions to the "SELECT" clause and returns a new query
`Query`	`rawFilter(String sql, Serializable... params)` Creates a custom condition and adds it to this query (using "AND" with an existing condition) and returns a new query
`Query`	`rawJoin(String table, String fld1, String fld2)` Adds an inner join with a given table, with the condition that the two given fields are equal, and returns a new query; all parameters are taken as raw SQL expressions
`Query`	`rawOrder(String... fields)` Adds the given raw SQL expressions to the "ORDER BY" clause and returns a new query
`Query`	`rawSet(String name, Serializable value)` Adds a field value (for INSERT or UPDATE) using a raw expression for the field, and returns a new query
`Query`	`select()` Runs this query as a SELECT (and caches the results)
`Query`	`select(Conn conn)` Runs this query as a SELECT using the given connection (and caches the results)
`Query`	`set(String name, Serializable value)` Adds a field value (for INSERT or UPDATE) and returns a new query
`Query`	`setExpr(String fieldExpr, String valueExpr, Serializable... params)` Adds a field value (for INSERT or UPDATE) using raw expressions for both the field and the value, and returns a new query
`void`	`startDeleteBatch(Conn conn, boolean keepParams)` Starts a batch DELETE using this query and the given connection
`void`	`startInsertBatch(Conn conn, boolean keepParams)` Starts a batch INSERT using this query and the given connection
`void`	`startUpdateBatch(Conn conn, boolean keepParams)` Starts a batch UPDATE using this query and the given connection
`Query`	`table(String tableName)` Sets the table to be queried and returns a new query
`Query`	`table(Table t)` Sets the table to be queried and returns a new query

Methods inherited from class net.aditsu.depeche.SQLQuery
addParams, executeBatch, getOneRecord, getProvider, getProviderRef, getRecord, update, update

Methods inherited from class net.aditsu.depeche.BaseQuery
clearData, get, getColumn, getColumn, getColumn, getColumn, getColumnInfo, getLocalQuery, getOneRecord, getRecord, hasRun, size

Methods inherited from class java.util.AbstractList
add, add, addAll, clear, equals, hashCode, indexOf, iterator, lastIndexOf, listIterator, listIterator, remove, set, subList

Methods inherited from class java.util.AbstractCollection
addAll, contains, containsAll, isEmpty, remove, removeAll, retainAll, toArray, toArray, toString

Methods inherited from class java.lang.Object
getClass, notify, notifyAll, wait, wait, wait

Methods inherited from interface net.aditsu.depeche.IQuery
clearData, getColumn, getColumn, getColumn, getColumn, getColumnInfo, getLocalQuery, getOneRecord, getRecord, hasRun

Methods inherited from interface java.util.List
add, add, addAll, addAll, clear, contains, containsAll, equals, get, hashCode, indexOf, isEmpty, iterator, lastIndexOf, listIterator, listIterator, remove, remove, removeAll, retainAll, set, size, subList, toArray, toArray

- Method Detail
  - copy
```
public Query copy()
```
    Description copied from interface: DynamicQuery
    
    Returns a copy of this query, without any cached results
    
    Specified by:
    
    copy in interface DynamicQuery
  - select
```
public Query select(Conn conn)
```
    Description copied from class: SQLQuery
    
    Runs this query as a SELECT using the given connection (and caches the results)
    
    Overrides:
    
    select in class SQLQuery
    
    Returns:
    this query
  - select
```
public Query select()
```
    Description copied from class: SQLQuery
    
    Runs this query as a SELECT (and caches the results)
    
    Specified by:
    
    select in interface IQuery
    
    Overrides:
    
    select in class SQLQuery
    
    Returns:
    this query
  - table
```
public Query table(String tableName)
```
    Sets the table to be queried and returns a new query
  - table
```
public Query table(Table t)
```
    Sets the table to be queried and returns a new query
  - filter
```
public Query filter(String name,
           Serializable value)
```
    Adds a condition that the column with the given name should have the given value, and returns a new query
    
    Specified by:
    
    filter in interface DynamicQuery
    
    See Also:
    Provider.filter(String, Serializable)
  - filter
```
public Query filter(KeyInfo keyInfo,
           Key key)
```
    Adds a condition to match a list of columns with a list of values, and returns a new query
    
    Specified by:
    
    filter in interface DynamicQuery
    
    See Also:
    Provider.filter(KeyInfo, Key)
  - filter
```
public Query filter(Record rec,
           KeyInfo cols)
```
    Description copied from interface: DynamicQuery
    
    Adds a condition to match a list of columns with a list of corresponding values from a Record, and returns a new query
    
    Specified by:
    
    filter in interface DynamicQuery
  - filter
```
public Query filter(Record rec,
           String... cols)
```
    Description copied from interface: DynamicQuery
    
    Adds a condition to match a list of columns with a list of corresponding values from a Record, and returns a new query
    
    Specified by:
    
    filter in interface DynamicQuery
  - filterIn
```
public Query filterIn(String name,
             Collection<? extends Serializable> values)
```
    Adds a "name IN (values)" condition and returns a new query
    
    Specified by:
    
    filterIn in interface DynamicQuery
    
    See Also:
    Provider.filterIn(String, Collection)
  - exclude
```
public Query exclude(String name,
            Serializable value)
```
    Adds a condition that the column with the given name should NOT have the given value, and returns a new query
    
    Specified by:
    
    exclude in interface DynamicQuery
    
    See Also:
    Provider.filter(String, Serializable)
  - exclude
```
public Query exclude(KeyInfo keyInfo,
            Key key)
```
    Adds a condition to NOT match a list of columns with a list of values, and returns a new query
    
    Specified by:
    
    exclude in interface DynamicQuery
    
    See Also:
    Provider.filter(KeyInfo, Key)
  - excludeIn
```
public Query excludeIn(String name,
              Collection<? extends Serializable> values)
```
    Adds a negative "name IN (values)" condition and returns a new query
    
    Specified by:
    
    excludeIn in interface DynamicQuery
    
    See Also:
    Provider.filterIn(String, Collection)
  - filter
```
public Query filter(String name,
           String op,
           Serializable value)
```
    Adds a "name operator value" condition and returns a new query
    
    Specified by:
    
    filter in interface DynamicQuery
    
    See Also:
    Provider.filter(String, String, Serializable)
  - exclude
```
public Query exclude(String name,
            String op,
            Serializable value)
```
    Adds a negative "name operator value" condition and returns a new query
    
    Specified by:
    
    exclude in interface DynamicQuery
    
    See Also:
    Provider.filter(String, String, Serializable)
  - filterPK
```
public Query filterPK(Serializable... values)
```
    Adds a condition that matches the primary key columns of the query's table to the given values and returns a new query
  - filterPK
```
public Query filterPK(List<Serializable> values)
```
    Adds a condition that matches the primary key columns of the query's table to the given values and returns a new query
  - filter
```
public Query filter(SQLCondition cond)
```
    Adds a SQL condition to this query (using "AND" with an existing condition) and returns a new query
  - filter
```
public Query filter(Condition cond)
```
    Description copied from interface: DynamicQuery
    
    Adds a condition to this query (using "AND" with an existing condition) and returns a new query
    
    Specified by:
    
    filter in interface DynamicQuery
  - exclude
```
public Query exclude(SQLCondition cond)
```
    Adds the negation of a SQL condition to this query (using "AND" with an existing condition) and returns a new query
  - exclude
```
public Query exclude(Condition cond)
```
    Description copied from interface: DynamicQuery
    
    Adds the negation of a condition to this query (using "AND" with an existing condition) and returns a new query
    
    Specified by:
    
    exclude in interface DynamicQuery
  - rawFilter
```
public Query rawFilter(String sql,
              Serializable... params)
```
    Creates a custom condition and adds it to this query (using "AND" with an existing condition) and returns a new query
  - getSelectSQL
```
public String getSelectSQL()
```
    Description copied from class: SQLQuery
    
    Returns the SQL string for running this query as a SELECT query
    
    Specified by:
    
    getSelectSQL in class SQLQuery
  - getDeleteSQL
```
public String getDeleteSQL()
```
    Returns the SQL string for running this query as a DELETE query
  - getUpdateSQL
```
public String getUpdateSQL()
```
    Returns the SQL string for running this query as an UPDATE query
    
    Specified by:
    
    getUpdateSQL in class SQLQuery
  - getInsertSQL
```
public String getInsertSQL()
```
    Returns the SQL string for running this query as an INSERT query
  - getParams
```
public List<Serializable> getParams()
```
    Description copied from class: SQLQuery
    
    Returns this query's parameters
    
    Specified by:
    
    getParams in class SQLQuery
  - limit
```
public Query limit(long x)
```
    Description copied from interface: DynamicQuery
    
    Limits the number of records to select and returns a new query
    
    Specified by:
    
    limit in interface DynamicQuery
  - offset
```
public Query offset(long x)
```
    Description copied from interface: DynamicQuery
    
    Sets the offset of the first record to select (i.e. number of records to skip), and returns a new query
    
    Specified by:
    
    offset in interface DynamicQuery
  - order
```
public Query order(String... fields)
```
    Description copied from interface: DynamicQuery
    
    Adds the given fields (ascending) to the list of fields to sort by, and returns a new query
    
    Specified by:
    
    order in interface DynamicQuery
  - order
```
public Query order(List<String> fields)
```
    Description copied from interface: DynamicQuery
    
    Adds the given fields (ascending) to the list of fields to sort by, and returns a new query
    
    Specified by:
    
    order in interface DynamicQuery
  - desc
```
public Query desc(String... fields)
```
    Description copied from interface: DynamicQuery
    
    Adds the given fields (descending) to the list of fields to sort by, and returns a new query
    
    Specified by:
    
    desc in interface DynamicQuery
  - desc
```
public Query desc(List<String> fields)
```
    Description copied from interface: DynamicQuery
    
    Adds the given fields (descending) to the list of fields to sort by, and returns a new query
    
    Specified by:
    
    desc in interface DynamicQuery
  - rawOrder
```
public Query rawOrder(String... fields)
```
    Adds the given raw SQL expressions to the "ORDER BY" clause and returns a new query
  - fields
```
public Query fields(String... fields)
```
    Description copied from interface: DynamicQuery
    
    Adds the given fields to the list of fields to select in each record, and returns a new query
    
    Specified by:
    
    fields in interface DynamicQuery
  - fields
```
public Query fields(List<String> fields)
```
    Description copied from interface: DynamicQuery
    
    Adds the given fields to the list of fields to select in each record, and returns a new query
    
    Specified by:
    
    fields in interface DynamicQuery
  - field
```
public Query field(String field,
          String alias)
```
    Description copied from interface: DynamicQuery
    
    Adds "field AS alias" to the list of fields to select in each record, and returns a new query
    
    Specified by:
    
    field in interface DynamicQuery
  - fields
```
public Query fields(List<String> fields,
           List<String> aliases)
```
    Description copied from interface: DynamicQuery
    
    Adds the given fields with the given aliases to the list of fields to select in each record, and returns a new query
    
    Specified by:
    
    fields in interface DynamicQuery
  - rawFields
```
public Query rawFields(String... fields)
```
    Adds the given raw SQL expressions to the "SELECT" clause and returns a new query
  - set
```
public Query set(String name,
        Serializable value)
```
    Adds a field value (for INSERT or UPDATE) and returns a new query
  - rawSet
```
public Query rawSet(String name,
           Serializable value)
```
    Adds a field value (for INSERT or UPDATE) using a raw expression for the field, and returns a new query
  - setExpr
```
public Query setExpr(String fieldExpr,
            String valueExpr,
            Serializable... params)
```
    Adds a field value (for INSERT or UPDATE) using raw expressions for both the field and the value, and returns a new query
  - insert
```
public int insert()
```
    Runs this query as an INSERT query and returns the number of rows
  - insert
```
public int insert(Conn conn)
```
    Runs this query as an INSERT query using the given connection and returns the number of rows
  - delete
```
public int delete()
```
    Runs this query as a DELETE query and returns the number of rows
  - delete
```
public int delete(Conn conn)
```
    Runs this query as a DELETE query using the given connection and returns the number of rows
  - count
```
public int count()
```
    Returns the number of rows that this SELECT query would find, as an int value. It calls BaseQuery.size() if the query has already run, otherwise runs a separate "SELECT COUNT(*)" query.
    
    Specified by:
    
    count in interface DynamicQuery
  - count
```
public int count(Conn conn)
```
    Returns the number of rows that this SELECT query would find, as an int value. It calls BaseQuery.size() if the query has already run, otherwise runs a separate "SELECT COUNT(*)" query using the given connection.
  - longCount
```
public long longCount()
```
    Returns the number of rows that this SELECT query would find, as a long value. It calls BaseQuery.size() if the query has already run, otherwise runs a separate "SELECT COUNT(*)" query.
    
    Specified by:
    
    longCount in interface DynamicQuery
  - longCount
```
public long longCount(Conn conn)
```
    Returns the number of rows that this SELECT query would find, as a long value. It calls BaseQuery.size() if the query has already run, otherwise runs a separate "SELECT COUNT(*)" query using the given connection.
  - startInsertBatch
```
public void startInsertBatch(Conn conn,
                    boolean keepParams)
```
    Starts a batch INSERT using this query and the given connection
    
    Parameters:
    conn - connection to use for preparing the statement
    keepParams - true to keep this query's parameters as the first set of parameters in the batch
  - startUpdateBatch
```
public void startUpdateBatch(Conn conn,
                    boolean keepParams)
```
    Starts a batch UPDATE using this query and the given connection
    
    Parameters:
    conn - connection to use for preparing the statement
    keepParams - true to keep this query's parameters as the first set of parameters in the batch
  - startDeleteBatch
```
public void startDeleteBatch(Conn conn,
                    boolean keepParams)
```
    Starts a batch DELETE using this query and the given connection
    
    Parameters:
    conn - connection to use for preparing the statement
    keepParams - true to keep this query's parameters as the first set of parameters in the batch
  - join
```
public Query join(Join join)
```
    Adds the given join object to the query's joins and returns a new query
  - rawJoin
```
public Query rawJoin(String table,
            String fld1,
            String fld2)
```
    Adds an inner join with a given table, with the condition that the two given fields are equal, and returns a new query; all parameters are taken as raw SQL expressions
  - join
```
public Query join(JoinType type,
         String table,
         String fld1,
         String fld2)
```
    Adds a join of a given type, with a given table, with the condition that the two given fields are equal, and returns a new query; all parameters are quoted
  - join
```
public Query join(String table,
         String fld1,
         String fld2)
```
    Adds an inner join with a given table, with the condition that the two given fields are equal, and returns a new query; all parameters are quoted
  - leftJoin
```
public Query leftJoin(String table,
             String fld1,
             String fld2)
```
    Adds a left join with a given table, with the condition that the two given fields are equal, and returns a new query; all parameters are quoted
  - joinParent
```
public Query joinParent(JoinType type,
               FKey fk)
```
    Adds a join of a given type, with a parent table, linked through the given foreign key
  - joinParent
```
public Query joinParent(FKey fk)
```
    Adds an inner join with a parent table, linked through the given foreign key
  - leftJoinParent
```
public Query leftJoinParent(FKey fk)
```
    Adds a left join with a parent table, linked through the given foreign key
  - joinParents
```
public Query joinParents(JoinType type)
```
    Adds joins of a given type, with all parent tables, linked through foreign keys
  - joinParents
```
public Query joinParents()
```
    Adds inner joins with all parent tables, linked through foreign keys
  - leftJoinParents
```
public Query leftJoinParents()
```
    Adds left joins with all parent tables, linked through foreign keys
  - joinParentFrom
```
public Query joinParentFrom(JoinType type,
                   String table)
```
    Adds a join of a given type, with the given parent table, linked through a foreign key
  - joinParentFrom
```
public Query joinParentFrom(String table)
```
    Adds an inner join with the given parent table, linked through a foreign key
  - leftJoinParentFrom
```
public Query leftJoinParentFrom(String table)
```
    Adds a left join with the given parent table, linked through a foreign key
  - joinParentThrough
```
public Query joinParentThrough(JoinType type,
                      String column)
```
    Adds a join of a given type, with a parent table, linked through the given column
  - joinParentThrough
```
public Query joinParentThrough(String column)
```
    Adds an inner join with a parent table, linked through the given column
  - leftJoinParentThrough
```
public Query leftJoinParentThrough(String column)
```
    Adds a left join with a parent table, linked through the given column
  - getTable
```
public String getTable()
```
    Returns the main table being queried
  - distinct
```
public Query distinct()
```
    Description copied from interface: DynamicQuery
    
    Adds the "DISTINCT" clause to the query, and returns a new query
    
    Specified by:
    
    distinct in interface DynamicQuery
  - lock
```
public Query lock(RowLock rowLock)
```
    Sets the given row lock (for SELECT) and returns a new query
  - isLimited
```
public boolean isLimited()
```
    Returns true if this query has a limit or offset

Class Query

Method Summary

Methods inherited from class net.aditsu.depeche.SQLQuery

Methods inherited from class net.aditsu.depeche.BaseQuery

Methods inherited from class java.util.AbstractList

Methods inherited from class java.util.AbstractCollection

Methods inherited from class java.lang.Object

Methods inherited from interface net.aditsu.depeche.IQuery

Methods inherited from interface java.util.List

Method Detail

copy

select

select

table

table

filter

filter

filter

filter

filterIn

exclude

exclude

excludeIn

filter

exclude

filterPK

filterPK

filter

filter

exclude

exclude

rawFilter

getSelectSQL

getDeleteSQL

getUpdateSQL

getInsertSQL

getParams

limit

offset

order

order

desc

desc

rawOrder

fields

fields

field

fields

rawFields

set

rawSet

setExpr

insert

insert

delete

delete

count

count

longCount

longCount

startInsertBatch

startUpdateBatch

startDeleteBatch

join

rawJoin

join

join

leftJoin

joinParent

joinParent

leftJoinParent

joinParents

joinParents

leftJoinParents

joinParentFrom

joinParentFrom

leftJoinParentFrom

joinParentThrough

joinParentThrough

leftJoinParentThrough