repeates each and everytime

[vamshi g]

hi
my query:
selecta.url,a.title, b.ticket_name, b.networkcommission, c.commision,d.user_id from group_partner a,price b,partner_ticket_commision c,user_profile d where a.partnerid=? and c.partnerid=a.partnerid and b.evt_id=c.eventid and b.evt_id=? and first_name=?


am getting the output,but some values are repeating,how to avoid this
thanks.

[Ananth Chellathurai]

Use joins.

Ananth Chellathurai

[David O'Meara]

"select distinct" may be the easiest

[Vijitha Kumara]

You are not joining user_profile d in the where clause. Aren't there a connection between that table and the others used in the query. If so join that too.

[Campbell Ritchie]

"Vamshi g" you need to read your private messages pronto.
[ September 20, 2008: Message edited by: Campbell Ritchie ]

[vamshi g]

There is no connection between user_profile and other tables.

[David O'Meara]

Originally posted by vamshi g:
There is no connection between user_profile and other tables.

Then you are in the same situation you were in here

[Jeanne Boyarsky]

Then let's close this thread and continue conversation in the other. No point in having two parallel discussions about the same thing.