# Reversing Join

**URL:** <https://forum.kirupa.com/t/reversing-join/269773>\
**Category:** programming\
**Created:** [September 1, 2008, 2:54pm UTC](https://forum.kirupa.com/t/reversing-join/269773 "2008-09-01T14:54:44Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![jvegas](https://avatars.discourse-cdn.com/v4/letter/j/7cd45c/32.png) [@jvegas](https://forum.kirupa.com/u/jvegas)\
**Post date:** [September 1, 2008, 2:54pm UTC](https://forum.kirupa.com/t/reversing-join/269773/1 "2008-09-01T14:54:44Z")

</div>

I have the statement

SELECT \*  
FROM  
a  
INNER JOIN b ON (a.foo = b.bar)

will give me all the fields that are linked, but is there a way to get all the enteries in both a and b that are not linked?