Is anyone could explain how the order of MySQL select table from multiple table? 1NF, 2NF then 3NF?
SELECT 1st_layer.1st_layer_ID FROM 1st_layer, 2nd Layer, 3rd_layer WHERE 2nd_layer.1st_layer_ID = 1st_layer.1st_layer_id AND 3rd_layer.2nd_layer_id = 2nd_layer.2nd_layer_id
Is this the correct order if i need to select from this three layer of table?
SELECT 1st_layer.1st_layer_ID FROM 1st_layer, 2nd Layer, 3rd_layer WHERE 2nd_layer.1st_layer_ID = 1st_layer.1st_layer_id AND 3rd_layer.2nd_layer_id = 2nd_layer.2nd_layer_id
Is this the correct order if i need to select from this three layer of table?