How to do..??

R

Rodrigo Borges

I have 2 tables with the following structure:

tServers:
servername
city

tTimezone
city
time1
time2

My query needs to check if [tServers].servername is like "*DOW*" and return
[tTimezone].time1. I have more conditions to do.. I joined both tables using
city.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to do..?? 1
Query to check a field and select fields from a table 3
How to do..?? 1
Subtracting 2 "time" fields 4
Using a formula 1
combining separate columns into one column in a query 2
Time between time 2
combining two tables into one 3

Top