return nil
		},
	).Where(map[string]any{"name": u2.Name}).First(ctx)
	if err != nil {
		t.Fatalf("Raw subquery join failed: %v", err)
	}
	if result.Name != u2.Name || result.Company.Name != u.Company.Name || result.Company.ID == 0 {
		t.Fatalf("Joins expected %s, got %+v", u.Name, result)
	}

	// Raw Subquery JOIN + WHERE + Select

		}

		if where, ok := q.db.Statement.Clauses["WHERE"].Expression.(clause.Where); ok {
			j.On = &where
		}

		if jt.Subquery != nil {
			joinType := j.JoinType
			if joinType == "" {
				joinType = clause.LeftJoin
			}

			if db, ok := jt.Subquery.(interface{ getInstance() *DB }); ok {
				stmt := db.getInstance().Statement
				if len(j.Selects) == 0 {
					j.Selects = stmt.Selects
				}