VJS Posted June 9, 2020 Share Posted June 9, 2020 Hi, Need help with SQL JOIN Currently I have the below SELECT * FROM T1 INNER JOIN T2 ON T1.Projectex = T2.WBS_Parent I need the join withut duplicating the sum values as highlighted in the JOIN table in the attached pic. Link to comment Share on other sites More sharing options...
Funce Posted June 9, 2020 Share Posted June 9, 2020 If you wished to do this, you'd need to explicitly write out all the columns you wished to output, rather than using the * wildcard. SELECT Projectex, ... Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now