我可以将联合查询转换为生成表查询吗? [英] Can I turn a union query into a make-table query?
问题描述
如何将以下内容转换为生成表查询?
SELECT [AddnlOwnrFName]& " " &安培; [AddnlOwnrLName] AS收件人来自
tblVehicleJobs INNER JOIN tblAddnlOwnrs ON tblVehicleJobs.VehicleJobID
= tblAddnlOwnrs.VehicleJobID WHERE
tblVehicleJobs.VehicleJobID = GetCurrentVehicleJobID() ;
UNION SELECT [LienHolderName] AS收件人来自tblVehicleJobs INNER
加入tblLienHolders ON tblVehicleJobs.VehicleJobID =
tblLienHolders.VehicleJobID WHERE
tblVehicleJobs.VehicleJobID = GetCurrentVehicleJobID();
UNION SELECT [OwnerFName]& " " &安培; [OwnerLName] AS收件人来自
tblVehicleJobs INNER JOIN tblOwners ON tblVehicleJobs.OwnerID =
tblOwners.OwnerID WHERE
tblVehicleJobs.VehicleJobID = GetCurrentVehicleJobID() ;
UNION SELECT IIf(IsNull([AuthCompany]),[AuthFName]&"&
[AuthLName],[AuthCompany] )作为收件人来自tblAuth INNER JOIN
tblVehicleJobs ON tblAuth.AuthID = tblVehicleJobs.AuthID WHERE
(tblVehicleJobs.VehicleJobID = GetCurrentVehicleJobI D())AND
(tblAuth.AuthCatID)<> 2;
UNION SELECT [ProxyFName]& " " &安培; [ProxyLName] AS收件人来自
tblVehicleJobs INNER JOIN tblProxies ON tblVehicleJobs.ProxyID =
tblProxies.ProxyID WHERE
tblVehicleJobs.VehicleJobID = GetCurrentVehicleJobID() ;
How can I turn the following into a make-table query?
SELECT [AddnlOwnrFName] & " " & [AddnlOwnrLName] AS Recipient FROM
tblVehicleJobs INNER JOIN tblAddnlOwnrs ON tblVehicleJobs.VehicleJobID
= tblAddnlOwnrs.VehicleJobID WHERE
tblVehicleJobs.VehicleJobID=GetCurrentVehicleJobID ();
UNION SELECT [LienHolderName] AS Recipient FROM tblVehicleJobs INNER
JOIN tblLienHolders ON tblVehicleJobs.VehicleJobID =
tblLienHolders.VehicleJobID WHERE
tblVehicleJobs.VehicleJobID=GetCurrentVehicleJobID ();
UNION SELECT [OwnerFName] & " " & [OwnerLName] AS Recipient FROM
tblVehicleJobs INNER JOIN tblOwners ON tblVehicleJobs.OwnerID =
tblOwners.OwnerID WHERE
tblVehicleJobs.VehicleJobID=GetCurrentVehicleJobID ();
UNION SELECT IIf(IsNull([AuthCompany]),[AuthFName] & " " &
[AuthLName],[AuthCompany]) AS Recipient FROM tblAuth INNER JOIN
tblVehicleJobs ON tblAuth.AuthID = tblVehicleJobs.AuthID WHERE
(tblVehicleJobs.VehicleJobID=GetCurrentVehicleJobI D()) AND
(tblAuth.AuthCatID)<>2;
UNION SELECT [ProxyFName] & " " & [ProxyLName] AS Recipient FROM
tblVehicleJobs INNER JOIN tblProxies ON tblVehicleJobs.ProxyID =
tblProxies.ProxyID WHERE
tblVehicleJobs.VehicleJobID=GetCurrentVehicleJobID ();
推荐答案
为什么要制作一张桌子?
PC数据表
为客户提供访问,Excel和Word帮助的资源
应用程序
重新* *****@pcdatasheet.com
" MLH" < CR ** @ NorthState.net写信息
新闻:e5 **************************** **** @ 4ax.com ...
Why do you want to make a table?
PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
re******@pcdatasheet.com
"MLH" <CR**@NorthState.netwrote in message
news:e5********************************@4ax.com...
如何将以下内容转换为生成表查询?
SELECT [AddnlOwnrFName]& " " &安培; [AddnlOwnrLName] AS收件人来自
tblVehicleJobs INNER JOIN tblAddnlOwnrs ON tblVehicleJobs.VehicleJobID
= tblAddnlOwnrs.VehicleJobID WHERE
tblVehicleJobs.VehicleJobID = GetCurrentVehicleJobID() ;
UNION SELECT [LienHolderName] AS收件人来自tblVehicleJobs INNER
加入tblLienHolders ON tblVehicleJobs.VehicleJobID =
tblLienHolders.VehicleJobID WHERE
tblVehicleJobs.VehicleJobID = GetCurrentVehicleJobID();
UNION SELECT [OwnerFName]& " " &安培; [OwnerLName] AS收件人来自
tblVehicleJobs INNER JOIN tblOwners ON tblVehicleJobs.OwnerID =
tblOwners.OwnerID WHERE
tblVehicleJobs.VehicleJobID = GetCurrentVehicleJobID() ;
UNION SELECT IIf(IsNull([AuthCompany]),[AuthFName]&"&
[AuthLName],[AuthCompany] )作为收件人来自tblAuth INNER JOIN
tblVehicleJobs ON tblAuth.AuthID = tblVehicleJobs.AuthID WHERE
(tblVehicleJobs.VehicleJobID = GetCurrentVehicleJobI D())AND
(tblAuth.AuthCatID)<> 2;
UNION SELECT [ProxyFName]& " " &安培; [ProxyLName] AS收件人来自
tblVehicleJobs INNER JOIN tblProxies ON tblVehicleJobs.ProxyID =
tblProxies.ProxyID WHERE
tblVehicleJobs.VehicleJobID = GetCurrentVehicleJobID() ;
How can I turn the following into a make-table query?
SELECT [AddnlOwnrFName] & " " & [AddnlOwnrLName] AS Recipient FROM
tblVehicleJobs INNER JOIN tblAddnlOwnrs ON tblVehicleJobs.VehicleJobID
= tblAddnlOwnrs.VehicleJobID WHERE
tblVehicleJobs.VehicleJobID=GetCurrentVehicleJobID ();
UNION SELECT [LienHolderName] AS Recipient FROM tblVehicleJobs INNER
JOIN tblLienHolders ON tblVehicleJobs.VehicleJobID =
tblLienHolders.VehicleJobID WHERE
tblVehicleJobs.VehicleJobID=GetCurrentVehicleJobID ();
UNION SELECT [OwnerFName] & " " & [OwnerLName] AS Recipient FROM
tblVehicleJobs INNER JOIN tblOwners ON tblVehicleJobs.OwnerID =
tblOwners.OwnerID WHERE
tblVehicleJobs.VehicleJobID=GetCurrentVehicleJobID ();
UNION SELECT IIf(IsNull([AuthCompany]),[AuthFName] & " " &
[AuthLName],[AuthCompany]) AS Recipient FROM tblAuth INNER JOIN
tblVehicleJobs ON tblAuth.AuthID = tblVehicleJobs.AuthID WHERE
(tblVehicleJobs.VehicleJobID=GetCurrentVehicleJobI D()) AND
(tblAuth.AuthCatID)<>2;
UNION SELECT [ProxyFName] & " " & [ProxyLName] AS Recipient FROM
tblVehicleJobs INNER JOIN tblProxies ON tblVehicleJobs.ProxyID =
tblProxies.ProxyID WHERE
tblVehicleJobs.VehicleJobID=GetCurrentVehicleJobID ();
MLH< CR ** @ NorthState.netwrote在
新闻:e5 ***** ***************************@4ax.com:
MLH <CR**@NorthState.netwrote in
news:e5********************************@4ax.com:
怎么能我将以下内容转换为生成表查询?
SELECT [AddnlOwnrFName]& " " &安培; [AddnlOwnrLName] AS收件人
FROM tblVehicleJobs INNER JOIN tblAddnlOwnrs ON
tblVehicleJobs.VehicleJobID = tblAddnlOwnrs.VehicleJobID WHERE
tblVehicleJobs.VehicleJobID = GetCurrentVehicleJobID() ;
UNION SELECT [LienHolderName] AS收件人来自tblVehicleJobs
INNER JOIN tblLienHolders ON tblVehicleJobs.VehicleJobID =
tblLienHolders.VehicleJobID WHERE
tblVehicleJobs.VehicleJobID = GetCurrentVehicleJobID();
UNION SELECT [OwnerFName]& " " &安培; [OwnerLName] AS收件人
FROM tblVehicleJobs INNER JOIN tblOwners ON
tblVehicleJobs.OwnerID = tblOwners.OwnerID WHERE
tblVehicleJobs.VehicleJobID = GetCurrentVehicleJobID() ;
UNION SELECT IIf(IsNull([AuthCompany]),[AuthFName]&"&
[AuthLName],[AuthCompany] )作为收件人来自tblAuth INNER
加入tblVehicleJobs ON tblAuth.AuthID = tblVehicleJobs.AuthID
WHERE(tblVehicleJobs.VehicleJobID = GetCurrentVehicleJobI D())
AND(tblAuth.AuthCatID)<> 2;
UNION SELECT [ProxyFName]& " " &安培; [ProxyLName] AS收件人
FROM tblVehicleJobs INNER JOIN tblProxies ON
tblVehicleJobs.ProxyID = tblProxies.ProxyID WHERE
tblVehicleJobs.VehicleJobID = GetCurrentVehicleJobID() ;
How can I turn the following into a make-table query?
SELECT [AddnlOwnrFName] & " " & [AddnlOwnrLName] AS Recipient
FROM tblVehicleJobs INNER JOIN tblAddnlOwnrs ON
tblVehicleJobs.VehicleJobID = tblAddnlOwnrs.VehicleJobID WHERE
tblVehicleJobs.VehicleJobID=GetCurrentVehicleJobID ();
UNION SELECT [LienHolderName] AS Recipient FROM tblVehicleJobs
INNER JOIN tblLienHolders ON tblVehicleJobs.VehicleJobID =
tblLienHolders.VehicleJobID WHERE
tblVehicleJobs.VehicleJobID=GetCurrentVehicleJobID ();
UNION SELECT [OwnerFName] & " " & [OwnerLName] AS Recipient
FROM tblVehicleJobs INNER JOIN tblOwners ON
tblVehicleJobs.OwnerID = tblOwners.OwnerID WHERE
tblVehicleJobs.VehicleJobID=GetCurrentVehicleJobID ();
UNION SELECT IIf(IsNull([AuthCompany]),[AuthFName] & " " &
[AuthLName],[AuthCompany]) AS Recipient FROM tblAuth INNER
JOIN tblVehicleJobs ON tblAuth.AuthID = tblVehicleJobs.AuthID
WHERE (tblVehicleJobs.VehicleJobID=GetCurrentVehicleJobI D())
AND (tblAuth.AuthCatID)<>2;
UNION SELECT [ProxyFName] & " " & [ProxyLName] AS Recipient
FROM tblVehicleJobs INNER JOIN tblProxies ON
tblVehicleJobs.ProxyID = tblProxies.ProxyID WHERE
tblVehicleJobs.VehicleJobID=GetCurrentVehicleJobID ();
将其保存为querydef。然后使用make table查询向导
来自该querydef的
。
-
Bob Quintal
PA是我已经改变了我的电子邮件地址。
-
通过 http://www.teranews.com
save it as a querydef. Then use the make table query wizard
sourced from that querydef.
--
Bob Quintal
PA is y I''ve altered my email address.
--
Posted via a free Usenet account from http://www.teranews.com
SELECT收件人
到新表格
来自
(
SELECT [AddnlOwnrFName]&" ;"& [AddnlOwnrLName] AS收件人来自
tblVehicleJobs INNER JOIN tblAddnlOwnrs ON tblVehicleJobs.VehicleJobID
= tblAddnlOwnrs.VehicleJobID WHERE
tblVehicleJobs。 VehicleJobID = GetCurrentVehicleJobID();
UNION SELECT [LienHolderName] AS收件人来自tblVehicleJobs INNER
加入tblLienHolders ON tblVehicleJobs.VehicleJobID =
tblLienHolders.VehicleJobID WHERE
tblVehicleJobs.VehicleJobID = GetCurrentVehicl eJobID();
UNION SELECT [OwnerFName]& " " &安培; [OwnerLName] AS收件人来自
tblVehicleJobs INNER JOIN tblOwners ON tblVehicleJobs.OwnerID =
tblOwners.OwnerID WHERE
tblVehicleJobs.VehicleJobID = GetCurrentVehicleJobID() ;
UNION SELECT IIf(IsNull([AuthCompany]),[AuthFName]&"&
[AuthLName],[AuthCompany] )作为收件人来自tblAuth INNER JOIN
tblVehicleJobs ON tblAuth.AuthID = tblVehicleJobs.AuthID WHERE
(tblVehicleJobs.VehicleJobID = GetCurrentVehicleJobI D())AND
(tblAuth.AuthCatID)<> 2;
UNION SELECT [ProxyFName]& " " &安培; [ProxyLName] AS收件人来自
tblVehicleJobs INNER JOIN tblProxies ON tblVehicleJobs.ProxyID =
tblProxies.ProxyID WHERE
tblVehicleJobs.VehicleJobID = GetCurrentVehicleJobID()
)
MLH写道:
SELECT Recipient
into newtable
from
(
SELECT [AddnlOwnrFName] & " " & [AddnlOwnrLName] AS Recipient FROM
tblVehicleJobs INNER JOIN tblAddnlOwnrs ON tblVehicleJobs.VehicleJobID
= tblAddnlOwnrs.VehicleJobID WHERE
tblVehicleJobs.VehicleJobID=GetCurrentVehicleJobID ();
UNION SELECT [LienHolderName] AS Recipient FROM tblVehicleJobs INNER
JOIN tblLienHolders ON tblVehicleJobs.VehicleJobID =
tblLienHolders.VehicleJobID WHERE
tblVehicleJobs.VehicleJobID=GetCurrentVehicleJobID ();
UNION SELECT [OwnerFName] & " " & [OwnerLName] AS Recipient FROM
tblVehicleJobs INNER JOIN tblOwners ON tblVehicleJobs.OwnerID =
tblOwners.OwnerID WHERE
tblVehicleJobs.VehicleJobID=GetCurrentVehicleJobID ();
UNION SELECT IIf(IsNull([AuthCompany]),[AuthFName] & " " &
[AuthLName],[AuthCompany]) AS Recipient FROM tblAuth INNER JOIN
tblVehicleJobs ON tblAuth.AuthID = tblVehicleJobs.AuthID WHERE
(tblVehicleJobs.VehicleJobID=GetCurrentVehicleJobI D()) AND
(tblAuth.AuthCatID)<>2;
UNION SELECT [ProxyFName] & " " & [ProxyLName] AS Recipient FROM
tblVehicleJobs INNER JOIN tblProxies ON tblVehicleJobs.ProxyID =
tblProxies.ProxyID WHERE
tblVehicleJobs.VehicleJobID=GetCurrentVehicleJobID ()
)
MLH wrote:
如何将以下内容变成一个make-表查询?
SELECT [AddnlOwnrFName]& " " &安培; [AddnlOwnrLName] AS收件人来自
tblVehicleJobs INNER JOIN tblAddnlOwnrs ON tblVehicleJobs.VehicleJobID
= tblAddnlOwnrs.VehicleJobID WHERE
tblVehicleJobs.VehicleJobID = GetCurrentVehicleJobID() ;
UNION SELECT [LienHolderName] AS收件人来自tblVehicleJobs INNER
加入tblLienHolders ON tblVehicleJobs.VehicleJobID =
tblLienHolders.VehicleJobID WHERE
tblVehicleJobs.VehicleJobID = GetCurrentVehicleJobID();
UNION SELECT [OwnerFName]& " " &安培; [OwnerLName] AS收件人来自
tblVehicleJobs INNER JOIN tblOwners ON tblVehicleJobs.OwnerID =
tblOwners.OwnerID WHERE
tblVehicleJobs.VehicleJobID = GetCurrentVehicleJobID() ;
UNION SELECT IIf(IsNull([AuthCompany]),[AuthFName]&"&
[AuthLName],[AuthCompany] )作为收件人来自tblAuth INNER JOIN
tblVehicleJobs ON tblAuth.AuthID = tblVehicleJobs.AuthID WHERE
(tblVehicleJobs.VehicleJobID = GetCurrentVehicleJobI D())AND
(tblAuth.AuthCatID)<> 2;
UNION SELECT [ProxyFName]& " " &安培; [ProxyLName] AS收件人来自
tblVehicleJobs INNER JOIN tblProxies ON tblVehicleJobs.ProxyID =
tblProxies.ProxyID WHERE
tblVehicleJobs.VehicleJobID = GetCurrentVehicleJobID() ;
How can I turn the following into a make-table query?
SELECT [AddnlOwnrFName] & " " & [AddnlOwnrLName] AS Recipient FROM
tblVehicleJobs INNER JOIN tblAddnlOwnrs ON tblVehicleJobs.VehicleJobID
= tblAddnlOwnrs.VehicleJobID WHERE
tblVehicleJobs.VehicleJobID=GetCurrentVehicleJobID ();
UNION SELECT [LienHolderName] AS Recipient FROM tblVehicleJobs INNER
JOIN tblLienHolders ON tblVehicleJobs.VehicleJobID =
tblLienHolders.VehicleJobID WHERE
tblVehicleJobs.VehicleJobID=GetCurrentVehicleJobID ();
UNION SELECT [OwnerFName] & " " & [OwnerLName] AS Recipient FROM
tblVehicleJobs INNER JOIN tblOwners ON tblVehicleJobs.OwnerID =
tblOwners.OwnerID WHERE
tblVehicleJobs.VehicleJobID=GetCurrentVehicleJobID ();
UNION SELECT IIf(IsNull([AuthCompany]),[AuthFName] & " " &
[AuthLName],[AuthCompany]) AS Recipient FROM tblAuth INNER JOIN
tblVehicleJobs ON tblAuth.AuthID = tblVehicleJobs.AuthID WHERE
(tblVehicleJobs.VehicleJobID=GetCurrentVehicleJobI D()) AND
(tblAuth.AuthCatID)<>2;
UNION SELECT [ProxyFName] & " " & [ProxyLName] AS Recipient FROM
tblVehicleJobs INNER JOIN tblProxies ON tblVehicleJobs.ProxyID =
tblProxies.ProxyID WHERE
tblVehicleJobs.VehicleJobID=GetCurrentVehicleJobID ();
这篇关于我可以将联合查询转换为生成表查询吗?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!