Adding column value dynamically in select statement SQL Query -

i have 2 sql tables below

table1

servername  downloaded  failed rebootrequried server1     3            2      yes server2     4            1      no 

table2

servername    administartor server1       john server3       alex 

i want join these 2 tables can extract administrator name out of table 2.

if servername of table 1 not matching servername of table2 , want retain columns servername,downloaded,failed, rebootrequired, administrator(which null).

if servername matches columns should retained including administrator name table2?

how can select statement in sql? pretty new ,and not sure how use conditional statement in sql

you need use left join. join tables1 , table2 on servername.

for more insight go through tutorials joins

select servername,downloaded,failed, rebootrequired, administrator table1 t1 left join table2 t2 on  t1.servername=t2.servername