If i wanted to Assign the Manager without a team to the team without a manager on a 1 year contacts

ive got as far as ?

UPDATE tbl_teams SET

Manager_ID =...

something like this?

SELECT Manager_ID FROM tbl_Managers

WHERE Manager_ID NOT IN

( SELECT Manager_ID FROM tbl_Teams WHERE Manager_ID IS NULL)

something like this?

SELECT Manager_ID FROM tbl_Manager

yes, i see what you mean regarding the first one

however im stuck with how to use JOIN on the second one

great thanks - i had one more question if thats ok

if i had to select the managers without a team ??

i can see this manager_id is...

or even

SELECT Team_Name FROM tbl_teams WHERE Manager_ID = 'NULL';

Thanks for the quick reply

so would something like this work?

SELECT Manager_ID FROM tbl_Teams WHERE value='NULL';