Results 1 to 6 of 6
Nov 3, 2012, 01:51 #1
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
$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?