List:General Discussion« Previous MessageNext Message »
From:Thomas Edison Jr. Date:September 27 2002 5:48am
Subject:DATABASE PROBLEM
View as plain text  
HI!
there is a problem in mysql database.there r two
tables.one table is named as transactions and the
other is named as the code.the transactions table has
got the 12 fields which r the following 1.clientid int
 2.date date  3.isinno text   4.debit int   5.credit
int  6.desc  text 
7.dpid1  text   8.nsdlid int   9. desc1 text  10.
desc2 text  11. dpid bigint  12.transno int 
All these fields r by default NULL
the code table has got the 8 fields which r the
following  1.rd smallint  2.transno int  
3.status tinyint  4.status1 tinyint 5.cdate date 
6.clientid int  7. isinno text 
8.description text  . All these fields r by default
NULL

I am writing this query but its not giving the
recquired results i.e i want it should pick up the all
the fields of both the tables without any duplicate
enteries.


SELECT * from transactions,holdings,code where 
transactions.clientid=holdings.clientid and
transactions.isinno=code.isinno
and transactions.isinno=' INE561A01013' and
transactions.transno='4509'AND 
FROM_DAYS(transactions.date) - TO_DAYS(holdings.hdate)
 group by transactions.credit,code.description 

Basically the problem with the above query is that its
giving the duplicate enteries .

plz. solve my problem at the earliest.its very  urgent.

=====
Rahul S. Johari (Director)
******************************************
Abraxas Technologies Inc.
Homepage : http://www.abraxastech.com
Email : abraxastech@stripped
Tel : 91-4546512/4522124
*******************************************

__________________________________________________
Do you Yahoo!?
New DSL Internet Access from SBC & Yahoo!
http://sbc.yahoo.com
Thread
DATABASE PROBLEMThomas Edison Jr.27 Sep