selecting data from 2 tables

selecting data from 2 tables

El Forum
Unregistered

#53

04-18-2011, 10:44 PM

[eluser]Bigil Michael[/eluser]
problem solved
this is the query

Quote:SELECT constituency_details.constituency_name, constituency_details.total_voters, constituency_details.total_polled ,candidate_details.candidate_name, candidate_details.candidate_party, candidate_details.candidate_votes FROM constituency_details , candidate_details WHERE candidate_details.constituency_id = constituency_details.constituency_id AND candidate_details.elect_year = $elect_year AND constituency_details.elect_year = $elect_year AND candidate_votes = (SELECT MAX(candidate_votes)FROM candidate_details WHERE elect_year=$elect_year AND candidate_details.constituency_id = constituency_details.constituency_id)

Messages In This Thread

selecting data from 2 tables - by El Forum - 04-16-2011, 12:43 AM

selecting data from 2 tables - by El Forum - 04-16-2011, 01:00 AM

selecting data from 2 tables - by El Forum - 04-16-2011, 01:09 AM

selecting data from 2 tables - by El Forum - 04-16-2011, 01:24 AM

selecting data from 2 tables - by El Forum - 04-16-2011, 01:30 AM

selecting data from 2 tables - by El Forum - 04-16-2011, 01:49 AM

selecting data from 2 tables - by El Forum - 04-16-2011, 02:21 AM

selecting data from 2 tables - by El Forum - 04-16-2011, 03:24 AM

selecting data from 2 tables - by El Forum - 04-16-2011, 03:46 AM

selecting data from 2 tables - by El Forum - 04-16-2011, 03:48 AM

selecting data from 2 tables - by El Forum - 04-16-2011, 04:03 AM

selecting data from 2 tables - by El Forum - 04-16-2011, 04:07 AM

selecting data from 2 tables - by El Forum - 04-16-2011, 04:15 AM

selecting data from 2 tables - by El Forum - 04-16-2011, 04:23 AM

selecting data from 2 tables - by El Forum - 04-16-2011, 04:41 AM

selecting data from 2 tables - by El Forum - 04-16-2011, 04:51 AM

selecting data from 2 tables - by El Forum - 04-16-2011, 04:52 AM

selecting data from 2 tables - by El Forum - 04-16-2011, 05:09 AM

selecting data from 2 tables - by El Forum - 04-16-2011, 05:56 AM

selecting data from 2 tables - by El Forum - 04-16-2011, 06:12 AM

selecting data from 2 tables - by El Forum - 04-16-2011, 06:25 AM

selecting data from 2 tables - by El Forum - 04-16-2011, 06:33 AM

selecting data from 2 tables - by El Forum - 04-16-2011, 06:38 AM

selecting data from 2 tables - by El Forum - 04-16-2011, 06:47 AM

selecting data from 2 tables - by El Forum - 04-18-2011, 12:34 AM

selecting data from 2 tables - by El Forum - 04-18-2011, 12:44 AM

selecting data from 2 tables - by El Forum - 04-18-2011, 12:51 AM

selecting data from 2 tables - by El Forum - 04-18-2011, 01:01 AM

selecting data from 2 tables - by El Forum - 04-18-2011, 01:03 AM

selecting data from 2 tables - by El Forum - 04-18-2011, 01:07 AM

selecting data from 2 tables - by El Forum - 04-18-2011, 01:09 AM

selecting data from 2 tables - by El Forum - 04-18-2011, 01:10 AM

selecting data from 2 tables - by El Forum - 04-18-2011, 01:17 AM

selecting data from 2 tables - by El Forum - 04-18-2011, 01:23 AM

selecting data from 2 tables - by El Forum - 04-18-2011, 01:29 AM

selecting data from 2 tables - by El Forum - 04-18-2011, 01:38 AM

selecting data from 2 tables - by El Forum - 04-18-2011, 01:45 AM

selecting data from 2 tables - by El Forum - 04-18-2011, 02:28 AM

selecting data from 2 tables - by El Forum - 04-18-2011, 02:40 AM

selecting data from 2 tables - by El Forum - 04-18-2011, 02:45 AM

selecting data from 2 tables - by El Forum - 04-18-2011, 03:04 AM

selecting data from 2 tables - by El Forum - 04-18-2011, 03:11 AM

selecting data from 2 tables - by El Forum - 04-18-2011, 03:15 AM

selecting data from 2 tables - by El Forum - 04-18-2011, 03:16 AM

selecting data from 2 tables - by El Forum - 04-18-2011, 03:22 AM

selecting data from 2 tables - by El Forum - 04-18-2011, 03:23 AM

selecting data from 2 tables - by El Forum - 04-18-2011, 03:25 AM

selecting data from 2 tables - by El Forum - 04-18-2011, 03:31 AM

selecting data from 2 tables - by El Forum - 04-18-2011, 03:33 AM

selecting data from 2 tables - by El Forum - 04-18-2011, 03:53 AM

selecting data from 2 tables - by El Forum - 04-18-2011, 04:52 AM

selecting data from 2 tables - by El Forum - 04-18-2011, 05:09 AM

selecting data from 2 tables - by El Forum - 04-18-2011, 10:44 PM

selecting data from 2 tables - by El Forum - 04-19-2011, 06:11 AM