List:General Discussion« Previous MessageNext Message »
From:Thomas Edison Jr. Date:September 27 2002 5:48am
View as plain text  
there is a problem in mysql database.there r two 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 date  3.isinno text   4.debit int
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

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

SELECT * from transactions,holdings,code where 
transactions.clientid=holdings.clientid and
and transactions.isinno=' INE561A01013' and
FROM_DAYS( - TO_DAYS(holdings.hdate)
 group by,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 :
Email : abraxastech@stripped
Tel : 91-4546512/4522124

Do you Yahoo!?
New DSL Internet Access from SBC & Yahoo!
DATABASE PROBLEMThomas Edison Jr.27 Sep