codeline Posted February 22, 2011 Share Posted February 22, 2011 I'm using an INNER JOIN to grab some data from 2 tables depending on if another's id matches an id within the other table (obviously.. ). Is there anyway to continue on with this join but to filter even deeper by only taking data that not only has matching some_id but also does not have a row that equals a certain value? Something along the lines of adding "WHERE some_row != 'value'" ? "SELECT * FROM my_firstTable INNER JOIN my_secondTable ON my_firstTable.some_id = my_secondTable.some_id ORDER BY my_firstTable.some_id" Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.