Home Forums SQL Server 2008 T-SQL (SS2K8) Some way to write an INNER JOIN, but joining on either of two columns RE: Some way to write an INNER JOIN, but joining on either of two columns

  • It's not clear what you're trying to accomplish. Some sample data and sample expected results would help to clear that up. If the mainzip and alternatezip both match rows in the zipcode table are you saying you just want the row that matches the mainzip returned, otherwise return whichever row matches?


    And then again, I might be wrong ...
    David Webb