By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
431,650 Members | 812 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 431,650 IT Pros & Developers. It's quick & easy.

Using multyple functions at the same statement

P: 1
I need to build a query that has like 8 Conditions. First condition is that from a CDR table get the calls that are "Terminating", second condition is that from those terminating calls take the ones that are "In", now when it gets complicated is after doing these 2 conditions I have a field in the CDR table that put categories to those calls that are A,B,C,D,E,and F, and on the second or Rate table I have the rates for A,B,C,D,E,and F as fields, so what I'm trying to do is to get the rates to those calls....Any help on this?
Sep 5 '08 #1
Share this Question
Share on Google+
1 Reply


puppydogbuddy
Expert 100+
P: 1,923
I need to build a query that has like 8 Conditions. First condition is that from a CDR table get the calls that are "Terminating", second condition is that from those terminating calls take the ones that are "In", now when it gets complicated is after doing these 2 conditions I have a field in the CDR table that put categories to those calls that are A,B,C,D,E,and F, and on the second or Rate table I have the rates for A,B,C,D,E,and F as fields, so what I'm trying to do is to get the rates to those calls....Any help on this?
You did not provide any details as to field names, etc. so the example below is a WAG;
Expand|Select|Wrap|Line Numbers
  1. Select tblCDR.Calls, tblCDR.Category, tblRates.Category, tblRates.Rate
  2. From tblCDR, tblRates
  3. Where tblCDR.CallType = "Terminating In"
  4. And tblCDR.Category = tblRates.Category
  5.  
Sep 7 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.