Inner Queries

Classic usage:

Select.from(db, tabAppUser)
	.where(tabAppUser.colUserId(),IN,
		Select.fieldList(db,tabUser.colUserId()).where(tabUser.colSso(),"ID12345"))
	.result()

Object related usage

Select.from(db, tabAppUser)
	.where(tabAppUser.colUserId(),IN,
		Select.from(db,tabUser).where(tabUser.colSso(),"ID12345"))
	.result()

Daobab sends the same sql query in both above scenarios.

Also accepts only correct inner queries, prevending agains commiting a mistake.

Innes query may have his own inner queries and so on.. there is no level limit.