I currently have a SQL database with four tables. I need to find a way to imalgamate these tables into one. The one table contains a postcode with around 15 or 16 employee numbers attached to it the people covering this area. I then have a staff table which all the employee numbers listed.
Is it possible to amalgamte my post table with the staff table i.e. calling the staff table to populate so for each postcode it will give the names of the staff member as well as there employee number.
Hope this makes sense
Is it possible to amalgamte my post table with the staff table i.e. calling the staff table to populate so for each postcode it will give the names of the staff member as well as there employee number.
Hope this makes sense