# ANSI Join converter wrongly add schema

**URL:** <https://forums.toadworld.com/t/ansi-join-converter-wrongly-add-schema/41645>\
**Category:** Toad for Oracle & DevOps Toolkit\
**Created:** [September 4, 2018, 8:31am UTC](https://forums.toadworld.com/t/ansi-join-converter-wrongly-add-schema/41645 "2018-09-04T08:31:18Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![tintinux](https://avatars.discourse-cdn.com/v4/letter/t/7feea3/32.png) [@tintinux](https://forums.toadworld.com/u/tintinux)\
**Post date:** [September 4, 2018, 8:31am UTC](https://forums.toadworld.com/t/ansi-join-converter-wrongly-add-schema/41645/1 "2018-09-04T08:31:19Z")

</div>

Hi

TOAD 12.10 can convert

```
SELECT *
  FROM table1 t1, table2 t2
  WHERE t1.code = t2.code(+);

```

to

```
SELECT * 
FROM myschema.table1 t1 LEFT OUTER JOIN myschema.table2 t2 f ON ( t1.code = t2.code);

```

The problem is there is no reason for adding the current schema name (myschema) before the table names. In our environment, this leads to bugs.

Can this be changed ?  
Thanks