FROM `office_a_log`.`nv200_init_sensor_header` AS SensorStats
JOIN `office_a_log`.`nv200_init_sensor_log` AS SensorValues
ON SensorStats.TestID = SensorValues.TestID;
What i want to do is to add another field in both tables called lets say joinName that has a value that i can configure like set it joinName='question',
in order to be able to join the tables by this field which will be the key.Any Ideas????