Hai folks,

we are recruiting candidates for 3 projects.
project a , project b and project c

candidats are put on 3 tables for the projects they were hired

candidates_project_a
candidates_project_b
candidates_project_c

i want to list all the candidats from 3 tables on the screen. we have total 400 candidates.

i have the flowing query

Code:
	$query="SELECT candidates_project_a.*, candidates_project_b.*, candidates_project_c.*
            From candidates_project_a, candidates_project_b, candidates_project_c
now this displays 14000+ records while i only have 400

what could be wrong?