加入两个查询？ [英] Join two queries?

问题描述

好的，我在加入这两个查询时遇到了问题。有人可以帮帮我吗。这些是我的两个查询的结果：


这些是QueryA的A1字段中的值

• COCKBURN 2
  
  GT KW 1
  
  GTN 1
  
  IPP GT1
  
  IPP GT2
  
  KALG F5
  
  KALG F6
  
  KWIN C6
  
  MUJA 1
  
  MUJA 2
  
  MUJA 3
  
  MUJA 4
  
  MUJA C5
  
  MUJA C6
  
  MUJA D7
  
  MUJA D8

这些是QueryB中字段A1和X1中的值：

展开 | 选择 | Wrap | 行号

解决方案

如果您发布有关表格的信息并向我们显示您的选择状态而不仅仅是您获得的信息，那将会更容易，也更有帮助。

我从中获取值两个不同的位置。 QueryA中的A1字段是客户文件中客户的位置。 A1字段是在第1天购买的客户的位置.X1字段是当天的购买金额。它来自另一个数据库。

这是我尝试过的一个声明：


SELECT *

FROM QueryA

LEFT OUTER JOIN

QueryB

ON QueryA.A1 = QueryB.A1


但是我得到一个错误（字段小到接受值....）

Ok, I have having a problem joing these two queries. Can anyone please help me out here. These are the results of my two queries:

These are the values in the A1 field of QueryA

• COCKBURN 2
  GT KW 1
  GTN 1
  IPP GT1
  IPP GT2
  KALG F5
  KALG F6
  KWIN C6
  MUJA 1
  MUJA 2
  MUJA 3
  MUJA 4
  MUJA C5
  MUJA C6
  MUJA D7
  MUJA D8

These are the values in fields A1 and X1 in QueryB:

Expand|Select|Wrap|Line Numbers

解决方案

It would be easier and more helpful if you posted information about your tables and show us your select statments instead of just the information you''re getting.

I am getting the values from two different locations. The A1 field in QueryA is the locations of customers from the customer file. The A1 field is the locations for customers that had a purchase on day 1. The X1 field is the purchase amount for that day. It is coming from another database.

This is one statement I have tried:

SELECT *
FROM QueryA
LEFT OUTER JOIN
QueryB
ON QueryA.A1 = QueryB.A1

but I get an error (field is to small to accept the value....)

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