The only reason I could see for this would be if you have duplicates (across date num1 num2 time) in both tables, or quadruplicates in one.
You join looks correct, so take a closer look at your data. Try running the following queries: SELECT A.date, num1, num2, A.time, Count(*) FROM A GROUP BY A.date, num1, num2, A.time HAVING Count(*) > 1 SELECT B.date, num1, num2, B.time, Count(*) FROM B GROUP BY B.date, num1, num2, B.time HAVING Count(*) > 1 HTH, Tore. ----- Original Message ----- From: "Ramesh Pillai" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, February 27, 2003 10:36 PM Subject: Inner join question! > All, > > I have two tables like the following > > table A > date num1 num2 time > > table B > date num1 num2 time > > When I run a query like the following > > select * from A as a inner join B as b > on a.num1 = b.num1 and a.date=b.date and a.num2=b.num2 > and a.time=b.time > > I am getting the results repeated 4 times, could > someone tell me why I am getting 4 rows and how can I > elliminate it? > > Thanks. > Ramesh > > __________________________________________________ > Do you Yahoo!? > Yahoo! Tax Center - forms, calculators, tips, more > http://taxes.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 > --------------------------------------------------------------------- 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
