Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Joining on Month& Year in Date column

I have 2  table with the below dates. SQL Server is the database. Table A 2016-03-31 2016-02-29 Table B 2016-03-1 2016-02-1 I have to join these 2 tables to get data for each month. However Inner join would fail and trying to extract month & year and joining in SQL, which is working fine. Table A.MONTH=Table B.MONTH AND Table A.YR=Table B.YR But how would i do this join in the universe level?

Former Member
Not what you were looking for? View more on this topic or Ask a question