How to do..??

[Rodrigo Borges]

I have 2 tables (tServers and tTimezone) with the following structure:

tServers:
servername
city

tTimezone:
city
time1
time2

My query need to check with [tServers].servername is like "*DOWD*" and
return a field "time" populating with [tTimezone].time2. I joined both tables
using city.

 

[Ofer Cohen]

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