'charlie') By default peewee will use an INNER join, but you can use LEFT OUTER, RIGHT OUTER, FULL, or CROSS joins as well: users = (User .select(User, fn.Count(Tweet.id).alias('num_tweets')) Join type may be one of: JOIN.INNER JOIN.LEFT_OUTER JOIN.RIGHT_OUTER JOIN.FULL JOIN.FULL_OUTER JOIN.CROSS left_outer_join(dest[, on=None]) dest (Source) – Join the table with the given destination on – __or__(dest) Parameters: Parameters: Perform a FULL OUTER join on dest. __mul__(dest) Perform a CROSS join on dest. class Table(name[, columns=None[, primary_key=None[, schema=None[, alias=None]]]])

'charlie') By default peewee will use an INNER join, but you can use LEFT OUTER, RIGHT OUTER, FULL, or CROSS joins as well: users = (User .select(User, fn.Count(Tweet.id).alias('num_tweets')) Join type may be one of: JOIN.INNER JOIN.LEFT_OUTER JOIN.RIGHT_OUTER JOIN.FULL JOIN.FULL_OUTER JOIN.CROSS left_outer_join(dest[, on=None]) dest (Source) – Join the table with the given destination on – RIGHT OUTER join on dest. __or__(dest) Perform a FULL OUTER join on dest. __mul__(dest) Perform a CROSS join on dest. class Table(name[, columns=None[, primary_key=None[, schema=None[, alias=None]]]])

'charlie') By default peewee will use an INNER join, but you can use LEFT OUTER, RIGHT OUTER, FULL, or CROSS joins as well: users = (User .select(User, fn.Count(Tweet.id).alias('num_tweets')) Join type may be one of: JOIN.INNER JOIN.LEFT_OUTER JOIN.RIGHT_OUTER JOIN.FULL JOIN.FULL_OUTER JOIN.CROSS left_outer_join(dest[, on=None]) dest (Source) – Join the table with the given destination on – RIGHT OUTER join on dest. __or__(dest) Perform a FULL OUTER join on dest. __mul__(dest) Perform a CROSS join on dest. class Table(name[, columns=None[, primary_key=None[, schema=None[, alias=None]]]])

'charlie') By default peewee will use an INNER join, but you can use LEFT OUTER, RIGHT OUTER, FULL, or CROSS joins as well: users = (User .select(User, fn.Count(Tweet.id).alias('num_tweets')) JOIN.LEFT_OUTER JOIN.RIGHT_OUTER JOIN.FULL JOIN.FULL_OUTER Parameters: Returns: Parameters: JOIN.CROSS left_outer_join(dest[, on=None]) dest (Source) – Join the table with the given destination on – RIGHT OUTER join on dest. __or__(dest) Perform a FULL OUTER join on dest. __mul__(dest) Perform a CROSS join on dest. class Table(name[, columns=None[, primary_key=None[, schema=None[, alias=None]]]])

'charlie') By default peewee will use an INNER join, but you can use LEFT OUTER, RIGHT OUTER, FULL, or CROSS joins as well: users = (User .select(User, fn.Count(Tweet.id).alias('num_tweets')) .join(Tweet, JOIN of: • JOIN.INNER • JOIN.LEFT_OUTER • JOIN.RIGHT_OUTER • JOIN.FULL • JOIN.FULL_OUTER • JOIN.CROSS left_outer_join(dest[, on=None]) Parameters • dest (Source) – Join the table with the given destination RIGHT OUTER join on dest. __or__(dest) Perform a FULL OUTER join on dest. __mul__(dest) Perform a CROSS join on dest. class Table(name[, columns=None[, primary_key=None[, schema=None[, alias=None]]]])

'charlie') By default peewee will use an INNER join, but you can use LEFT OUTER, RIGHT OUTER, FULL, or CROSS joins as well: users = (User .select(User, fn.Count(Tweet.id).alias('num_tweets')) .join(Tweet, JOIN of: • JOIN.INNER • JOIN.LEFT_OUTER • JOIN.RIGHT_OUTER • JOIN.FULL • JOIN.FULL_OUTER • JOIN.CROSS 1.14. API Documentation 127 peewee Documentation, Release 3.3.0 left_outer_join(dest[, on=None]) RIGHT OUTER join on dest. __or__(dest) Perform a FULL OUTER join on dest. __mul__(dest) Perform a CROSS join on dest. class Table(name[, columns=None[, primary_key=None[, schema=None[, alias=None]]]])

'charlie') By default peewee will use an INNER join, but you can use LEFT OUTER, RIGHT OUTER, FULL, or CROSS joins as well: users = (User .select(User, fn.Count(Tweet.id).alias('num_tweets')) .join(Tweet, JOIN of: • JOIN.INNER • JOIN.LEFT_OUTER • JOIN.RIGHT_OUTER • JOIN.FULL • JOIN.FULL_OUTER • JOIN.CROSS left_outer_join(dest[, on=None]) Parameters • dest (Source) – Join the table with the given destination RIGHT OUTER join on dest. __or__(dest) Perform a FULL OUTER join on dest. __mul__(dest) Perform a CROSS join on dest. class Table(name[, columns=None[, primary_key=None[, schema=None[, alias=None]]]])

Join type may be one of: JOIN.INNER JOIN.LEFT_OUTER JOIN.RIGHT_OUTER JOIN.FULL JOIN.FULL_OUTER JOIN.CROSS left_outer_join(dest[, on=None]) dest (Source) – Join the table with the given destination on – RIGHT OUTER join on dest. __or__(dest) Perform a FULL OUTER join on dest. __mul__(dest) Perform a CROSS join on dest. Parameters: Parameters: Parameters: class Table(name[, columns=None[, primary_key=None[ Join type may be one of: JOIN.INNER JOIN.LEFT_OUTER JOIN.RIGHT_OUTER JOIN.FULL JOIN.FULL_OUTER JOIN.CROSS Express a JOIN: User = Table('users', ('id', 'username')) Note = Table('notes', ('id', 'user_id'

of: • JOIN.INNER • JOIN.LEFT_OUTER • JOIN.RIGHT_OUTER • JOIN.FULL • JOIN.FULL_OUTER • JOIN.CROSS left_outer_join(dest[, on=None]) Parameters • dest (Source) – Join the table with the given destination RIGHT OUTER join on dest. __or__(dest) Perform a FULL OUTER join on dest. __mul__(dest) Perform a CROSS join on dest. class Table(name[, columns=None[, primary_key=None[, schema=None[, alias=None]]]]) API Documentation 139 peewee Documentation, Release 3.6.0 • JOIN.FULL • JOIN.FULL_OUTER • JOIN.CROSS Express a JOIN: User = Table('users', ('id', 'username')) Note = Table('notes', ('id', 'user_id'

'charlie') By default peewee will use an INNER join, but you can use LEFT OUTER, RIGHT OUTER, FULL, or CROSS joins as well: users = (User .select(User, fn.Count(Tweet.id).alias('num_tweets')) be specified explicitly, one of JOIN.INNER, JOIN.LEFT_OUTER, JOIN.FULL, JOIN.RIGHT_OUTER, or JOIN.CROSS. on – if multiple foreign keys exist between two models, this parameter is the ForeignKeyField to