Jump to content

Aahi


VJS
 Share

Recommended Posts

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.

 

sql query.jpg

Link to comment
Share on other sites

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

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...