Pulling data from identical tables
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
i want to list all the candidats from 3 tables on the screen. we have total 400 candidates.
i have the flowing query
now this displays 14000+ records while i only have 400 :rolleyes:
$query="SELECT candidates_project_a.*, candidates_project_b.*, candidates_project_c.*
From candidates_project_a, candidates_project_b, candidates_project_c
what could be wrong?