How to do..??

[Guest]

I have 2 tables with the following structure:

tServers:
servername
city

tTimezone
city
time1
time2

I need to build a query that checks if [tServers].servername is like
"*DOWD*" then the field will be populated with [tTimezone].time2

I joined both tables using city... how to do this query?

 

[Guest]

Not sure if that what you mean, but try

SELECT tServers.servername , tTimezone.time2
FROM tServers INNER JOIN tTimezone ON tServers.city = tTimezone.city
WHERE tServers.servername Like "*DOWD*"

Please post back if I'm not in the right direction