Relationship between tables

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server Newbies » Relationship between tables

Relationship between tables

Rate Topic

Display Mode

Topic Options

Author

Message

fodex7l

Posted Tuesday, October 16, 2012 1:29 PM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, October 17, 2012 10:52 AM
Points: 2, Visits: 3

Hi, this query returns almost all that I need, but NUMEROCCF from TPRD is missing. If I just add it to that, the number of rows grows exceeding what was expected and messing up query's results, including total value.

So how to join NUMEROCCF to this query as additional info, so row's quantity remains the same??

Thank you!

Post #1373494

Lowell

Posted Tuesday, October 16, 2012 1:37 PM

SSChampion

Group: General Forum Members
Last Login: Today @ 10:38 AM
Points: 11,610, Visits: 27,659

where's the query you are refering to? did you forget to paste it so we can help you?

Lowell

--There is no spoon, and there's no default ORDER BY in sql server either.
Actually, Common Sense is so rare, it should be considered a Superpower. --my son

Post #1373496

fodex7l

Posted Wednesday, October 17, 2012 8:03 AM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, October 17, 2012 10:52 AM
Points: 2, Visits: 3

OMG, sorry... forgot to post the query, here you go:

use corporerm
select datepart(year,M.DATAEMISSAO) AS ANO, DATEPART(MONTH,M.DATAEMISSAO) AS MÊS, M.NUMEROMOV AS NOTA,
(SELECT M.VALORLIQUIDO) AS 'VALOR TOTAL' FROM TITMMOV IM

INNER JOIN DNATUREZA D ON D.CODNAT = D.CODNAT
INNER JOIN TMOV M ON M.IDMOV = IM.IDMOV
INNER JOIN TPRD P ON P.IDPRD = IM.IDPRD
INNER JOIN TUND U ON U.CODUND = IM.CODUND

WHERE D.CODNAT IN ('5.101', '5.101.01', '5.101.02', '5.101.03', '6.101', '6.101.02', '7.101.01', '5.124.01', '5.124', '7.101')
AND M.STATUS not in ('C') AND CODTMV IN ('2.2.01', '2.2.02', '2.2.04', '2.2.14', '2.2.15')
AND IM.CODCOLIGADA = 1 AND P.CODCOLIGADA = 1 AND DATEPART(YEAR,M.DATAEMISSAO)= 2012
AND DATEPART(MONTH,M.DATAEMISSAO)= 9 AND M.SERIE = '1'

GROUP BY DATEPART(YEAR,M.DATAEMISSAO),DATEPART(MONTH,M.DATAEMISSAO), M.NUMEROMOV, M.VALORLIQUIDO

Post #1373806

« Prev Topic | Next Topic »

Permissions