我可以将联合查询转换为生成表查询吗？

问题描述

如何将以下内容转换为生成表查询？


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 ();

推荐答案

将其保存为querydef。然后使用make table查询向导
来自该querydef的
。


-

Bob Quintal


PA是我已经改变了我的电子邮件地址。


-

通过

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

这篇关于我可以将联合查询转换为生成表查询吗？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！