# Is it mandatory to create that auxiliary table for HABTM?

**URL:** <https://www.ruby-forum.com/t/is-it-mandatory-to-create-that-auxiliary-table-for-habtm/104888>\
**Category:** Rails\
**Created:** [May 23, 2007, 4:26pm UTC](https://www.ruby-forum.com/t/is-it-mandatory-to-create-that-auxiliary-table-for-habtm/104888 "2007-05-23T16:26:07Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![coelho](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/c/e9c0ed/32.png) [@coelho](https://www.ruby-forum.com/u/coelho)\
**Post date:** [May 23, 2007, 4:26pm UTC](https://www.ruby-forum.com/t/is-it-mandatory-to-create-that-auxiliary-table-for-habtm/104888/1 "2007-05-23T16:26:07Z")

</div>

Hello,

Is there a way to create those has\_and\_belongs\_to\_many without the need  
of an auxiliary table ?

coelho

---

<div class="post-metadata">

**Author:** ![coelho](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/c/e9c0ed/32.png) [@coelho](https://www.ruby-forum.com/u/coelho)\
**Post date:** [May 23, 2007, 5:08pm UTC](https://www.ruby-forum.com/t/is-it-mandatory-to-create-that-auxiliary-table-for-habtm/104888/2 "2007-05-23T17:08:29Z")

</div>

Hi,

Can you imagine two SQL tables with many-many relationship without a  
third join table?  
I can’t.

Cheers,  
Yuri