How to remove inner join with gui?

[Robbie]

Hi all,
I'm making a query in design view and when I chose the tables I wanted to
use and it automatically seemed to know which fields to join. Normally I
would welcome this but the actual problem I'm having prevents me from using
the join on this field because the data is actually missing on one of the
tables so the query would not show me what I need.

So I want to join using another common field instead. I already corrected
this in SQL View but I was wondering if there was a way to remove the join
with a couple of clicks or menu option.

 

[Douglas J. Steele]

Just click on the line to highlight it, then right-click and select Delete
from the context menu (or if you're sure you've selected it, hit the Delete
key)

 

[Klatuu]

right click on the join line between the tables in design view. Depending on
whether you are on the line correctly, you will get either a menu of stuff or
the option to edit or delete the join. Delete the join, then create your own
join

 

[Robbie]

Thanks.