combine two queries to external database

[Scott Sabo]

Hello-

I have two DB's, say DB#1 & DB#2. DB#2 has two queries which look to
DB#1 for information. I have two queries because I am looking at
information in two seperate tables in DB#1 and did not know how to
combine them. I will post the SQL below, can someone show me how this
could be written in one query?

Query #1:
SELECT ItemPriceTolerance.EffectiveCost, ItemPriceTolerance.ItemNo
FROM ItemPriceTolerance IN 'c:\documents and
settings\sabosis\desktop\electronic price book.mdb';


Query #2:
SELECT ProductsData.ItemNo, ProductsData.ItemDesc,
ProductsData.Vendor, ProductsData.CaseQuantity
FROM ProductsData IN 'c:\documents and
settings\sabosis\desktop\electronic price book.mdb';

Thanks-

Scott

 

[MGFoster]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

SELECT IP.EffectiveCost, IP.ItemNo,
PD.ItemDesc, PD.Vendor, PD.CaseQuantity
FROM ItemPriceTolerance IN 'c:\documents and
settings\sabosis\desktop\electronic price book.mdb' As IP
INNER JOIN ProductsData IN 'c:\documents and
settings\sabosis\desktop\electronic price book.mdb' As PD
ON IP.ItemNo = PD.ItemNo

This may be a real slow query, since it is a heterogenous query
(querying tables in another database) and may read all the ItemNo values
from each table.

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQUcYzIechKqOuFEgEQJEGQCgpHRtbB7UtpUL0noeNZgM/PNds4QAnipC
SzeGKThRNOlfnOwNwV5QNiWf
=v/zE
-----END PGP SIGNATURE-----