# Interface SQLiteSelectJoinConfig

interface SQLiteSelectJoinConfig {
alias: string | undefined;
joinType: JoinType;
on: SQL<unknown> | undefined;
table:
| SQLiteTable<TableConfig>
| SQLiteViewBase<string, boolean, ColumnsSelection>
| SQL<unknown>
| Subquery<string, Record<string, unknown>>;
}

- Defined in node_modules/.pnpm/drizzle-orm@0.44.6_@cloudflare+workers-types@4.20251014.0_@opentelemetry+api@1.9.0_@typ_31a6f5ca8f102af87864dd251ed08d88/node_modules/drizzle-orm/sqlite-core/query-builders/select.types.d.ts:14

##### Index

### Properties

alias
joinType
on
table

## Properties

### alias

alias: string | undefined

- Defined in node_modules/.pnpm/drizzle-orm@0.44.6_@cloudflare+workers-types@4.20251014.0_@opentelemetry+api@1.9.0_@typ_31a6f5ca8f102af87864dd251ed08d88/node_modules/drizzle-orm/sqlite-core/query-builders/select.types.d.ts:17

### joinType

joinType: JoinType

- Defined in node_modules/.pnpm/drizzle-orm@0.44.6_@cloudflare+workers-types@4.20251014.0_@opentelemetry+api@1.9.0_@typ_31a6f5ca8f102af87864dd251ed08d88/node_modules/drizzle-orm/sqlite-core/query-builders/select.types.d.ts:18

### on

on: SQL<unknown> | undefined

- Defined in node_modules/.pnpm/drizzle-orm@0.44.6_@cloudflare+workers-types@4.20251014.0_@opentelemetry+api@1.9.0_@typ_31a6f5ca8f102af87864dd251ed08d88/node_modules/drizzle-orm/sqlite-core/query-builders/select.types.d.ts:15

### table

table:
| SQLiteTable<TableConfig>
| SQLiteViewBase<string, boolean, ColumnsSelection>
| SQL<unknown>
| Subquery<string, Record<string, unknown>>

- Defined in node_modules/.pnpm/drizzle-orm@0.44.6_@cloudflare+workers-types@4.20251014.0_@opentelemetry+api@1.9.0_@typ_31a6f5ca8f102af87864dd251ed08d88/node_modules/drizzle-orm/sqlite-core/query-builders/select.types.d.ts:16