查询问题 [英] Problem with Query

问题描述

Hi Byte社区！我的查询有问题，我需要你的专家意见。


好​​的，我有两个问题;第一个在列中有这种类型的信息：


CombinedPlan1

CombinedPlan2

CombinedPlan3


需要在另一个名为Rates的查询中查找每个列的结果。我需要返回基于CombinedPlan 1-3的4（单一费率，家庭等）信息列。这真让我抓狂。如何从查询中提取此信息？


谢谢，如果您需要更多信息，请告诉我。我希望它不会太混乱。


Kelly

Hi Byte community! I''m having a problem with a query and I need your expert advice.

Okay, I have two queries; the first one has this type of information in columns:

CombinedPlan1
CombinedPlan2
CombinedPlan3

The results of each of these columns need to be looked up in another query called "Rates". I need to return 4 (Single rates, Family, etc.) columns of information based on CombinedPlan 1-3. This is driving me crazy. How can I pull this information from the query?

Thanks, let me know if you need more information. I hope it''s not too confusing.

Kelly

推荐答案

我担心你需要解释这更好凯利。我几乎不知道你在说什么：（

I''m afraid you will need to explain this better Kelly. I barely have a clue what you''re talking about :(

好的。这有点难以解释，但我会尽力做得更好。:)


我有两个问题。第一个查询包含如下信息列：

Okay. It is kind of hard to explain, but I will try to do better. :)

I have two queries. The first query has columns of information like this:

展开 | 选择 | Wrap | 行号

我是否认为你想要一个类似的输出？ ：

Am I right in thinking that you want an output something like? :

展开 | 选择 | Wrap | 行号

这篇关于查询问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！