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 : [EMAIL PROTECTED] Tel : 91-4546512/4522124 ******************************************* __________________________________________________ Do you Yahoo!? New DSL Internet Access from SBC & Yahoo! http://sbc.yahoo.com --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
