Hi Cindy,
SELECT Inventory.*, Customer.Name from Inventory Left Join Customer on
Inventory.PurchasedBy = Customer.ID
where Inventory.PurchasedBy = Custormer.ID;
Your query is an equi-join query, which means that there should be data
for only those rows for which the equality in
the w
he job.
Sundru,
megasoft Ltd,
Chennai, India.
- Original Message -
From: "Cindy" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, January 02, 2002 12:42 PM
Subject: question on selects in multiple tables
>
> OK... let's say I have two tables. Let
At 01.01.2002 23:12, you wrote:
>OK... let's say I have two tables. Let's say one is an inventory
>table, a bunch of items. One of the fields is for the inventory
>items that have been sold, and are keys to the second table, which
>is a list of customers; names & addresses.
>
>So let's say I w
OK... let's say I have two tables. Let's say one is an inventory
table, a bunch of items. One of the fields is for the inventory
items that have been sold, and are keys to the second table, which
is a list of customers; names & addresses.
So let's say I want to pull out all inventory items acq
