query - 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

query

Author

Topic

asm
Posting Yak Master

140 Posts

Posted - 2005-10-21 : 02:44:36

HI EVERYBODY...

PLEASE HELP ME TO SOLVE THIS PROBLEM..

I HAVE TO GENERATE A REPORT FOT THAT I FIRE TWO QUERY...

QUERY : 1
---------------
SELECT GEN.GLCODE, GEN.GLNAME, GEN.CBCODE, GEN.CB
FROM GEN
WHERE (((GEN.CB)='Y'));

---> IT WILL RETRIVE THE CASH / BANK NAME FORM GEN TABLE

QUERY : 2
---------------
SELECT PARTY.PARTYNAME AS PARTYNAME, GENM.GLNAME AS GLNAME, GENM.OPBAL AS OAMOUNT,
GENCASH.GLNAME AS CASHNAME, TXN.CBCODE AS CBCODE, GENM.CB AS CB, TXN.GLCODE AS GLCODE,
TXN.VOUCHER AS VOUCHER, TXN.DOCDATE AS DOCDATE, TXN.AMOUNT AS TAMOUNT, TXN.VTYPE AS VTYPE,
TXN.NARR AS NARR, TXN.CHEQUE AS CHEQUE, TXN.CHEQDATE AS CHEQDATE, TXN.BANK AS BANK,
TXN.BILLNO AS BILLNO, TXN.BILLDT AS BILLDT
FROM PARTY RIGHT JOIN (GEN AS GENM LEFT JOIN (TXN LEFT JOIN GENCASH ON TXN.CBCODE=GENCASH.CBCODE) ON GENM.GLCODE=TXN.GLCODE) ON PARTY.PARTYCODE=TXN.PARTYCODE
WHERE GENM.CB='N';

---> THIS WILL RETRIVE THE ALL DATA FROM TXN, GEN, PARTY, GENCASH IS LINKED ON CBCODE WITH TXN

HOW CAN I GET THIS RESULT WITH SINGLE QUERY...

THANKS

ASM

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2005-10-21 : 02:47:42

General Approach is

Select T1.*,T2.* from
	(
	First query
	) T1
inner join
	(
	Second query
	) T2
on T1.col=T2.col

where col is the common column of both the result sets

Madhivanan

Failing to plan is Planning to fail

activecrypt
Posting Yak Master

165 Posts

Posted - 2005-10-24 : 01:20:02

Hi,
to understand this please read joining tables, overview
under BOl , BOL has very good examples for almost everything you wants.

-----------------------------------------------------------
MSSQL Server encryption software http://www.activecrypt.com

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources