Query to check a field and select fields from a table

[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 if [tServers].servername is like "*DOWD*" and
return a field "time" populating with [tTimezone].time2. I joined both
tables using city.

 

[Carl Rapson]

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

tServers:
servername
city

tTimezone:
city
time1
time2

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

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

Carl Rapson

 

[Rodrigo Borges]

I do need to use a condicional because I have more than 1 information to
check...

exampe: if servername like "*dowd*" = time2, if servername like *dowb* =
time1....

Tks for your reply Carl and soory for do not provide these information
before...

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

tServers:
servername
city

tTimezone:
city
time1
time2

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

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

Carl Rapson

 

[Carl Rapson]

I don't think that can be done in a query, because you can't conditionally
specify the fields to be selected. It would be fairly simple in VBA code.

Carl Rapson

I do need to use a condicional because I have more than 1 information to
check...

exampe: if servername like "*dowd*" = time2, if servername like *dowb* =
time1....

Tks for your reply Carl and soory for do not provide these information
before...

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

tServers:
servername
city

tTimezone:
city
time1
time2

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

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

Carl Rapson