unique record - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

unique record

Author

Topic

asm
Posting Yak Master

140 Posts

Posted - 2005-10-24 : 06:44:07

HI

I HAVE THREE TABLE GEN, PARTY, TXN (GEN & PARRTY IS MASTER TABLE AND
TXN IS TRANSACTION TABLE)
IN TXN TABLE - STORE ALL DATA IN WHICH SAME VOUCHER NUMBER IS REPEATED
ACCORDING TO JOURNAL ENTRY)
NOW PROBLEM IS THIS AT THE TIME OF DISPLAY THE RECORD ON SCREEN I HAVE
TO SHOW ONLY THE UNIQUE VOUCHER NUMBER ONLY..

PLS GUIDE IN THIS QUERY HOW CAN I GET THAT RESULT.

SELECT DISTINCT TXN.VOUCHER, GEN.GLNAME, PARTY.PARTYNAME, TXN.DOCDATE, TXN.GLCODE, TXN.PARTYCODE, TXN.AMOUNT, TXN.VTYPE, TXN.CBCODE, TXN.ADJ, TXN.DC, TXN.NARR
FROM (TXN LEFT JOIN GEN ON GEN.GLCODE=TXN.GLCODE) LEFT JOIN PARTY ON PARTY.PARTYCODE=TXN.PARTYCODE
WHERE TXN.VTYPE='JV'
ORDER BY TXN.VOUCHER

THANKS

ASM

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2005-10-24 : 07:14:48

Post sample data and the result you want

Madhivanan

Failing to plan is Planning to fail

asm
Posting Yak Master

140 Posts

Posted - 2005-10-24 : 07:39:59

table txn:
voucher glcode partycode
01 g1
01 s1 p01
02 gg
02 ss
02 cc

result should be
voucher glcode partycode glname partyname
01 s1 p01 debotr abc co
02 gg rent

asm

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2005-10-24 : 07:54:00

Sample data are not enough
Post some sample data from all tables and the result you want

Madhivanan

Failing to plan is Planning to fail

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources