Members   Search   Help    Register    Login   Home

Show: Today's Messages  :: Show Polls :: Message Navigator

Query with joins repeats first match [message #448] Tue, 05 December 2006 06:12  migandhi Messages: 9 Registered: December 2006 Junior Member i am facing a problem in a join query . it contains multiple joins . the output for example is like , --------------------------------------- 10 abc 123 10 abc 123 10 abc 123 --------------------------------------- and so on .... i tried it with and without indexing . but the result set is the same. the first match in the query is repeated . the tables are Innodb type , which would also permit foreign key. i am working on version 5.0 Report message to a moderator

	Query with joins repeats first match By: migandhi on Tue, 05 December 2006 06:12
	Re: Query with joins repeats first match By: Peter on Tue, 05 December 2006 06:56
	Re: Query with joins repeats first match By: migandhi on Tue, 05 December 2006 10:13
	Re: Query with joins repeats first match By: carpii on Thu, 07 December 2006 18:25
	Re: Query with joins repeats first match By: Peter on Fri, 08 December 2006 13:40
	Re: Query with joins repeats first match By: migandhi on Sat, 23 December 2006 00:35

Previous Topic:	Assistance Needed with Table Corruption
Next Topic:	OR & AND?

Goto Forum:

[ Generate printable PDF ] [ Syndicate this forum (XML) ] [ ]