Hi Everyone, I have two tables: table1: history dayid nofile servername11082012 1 server112082012 1 server213082012 1 server314082012 1 server1* table2 servers: serverName unitserver1 emeaserver2 uaeserver3 emea I wrote a querry to join tables:
select history.dayid, history.nofile, history.servername, servers.unitfrom historyleft joinserversonhistory.servername = servers.serverName
In my case server1* is the same as server1but SQL see that as a different names. Is there a possibility to join the tables without empty cells?I'd like to avoid creating temporary tables. Thank You for answering my question.