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
Hi,
I faced the same problem, but the solution to this is you is you add as many
qualifiers as you can (i'm sure there are more elegant ways to do it but it
works for me:-))specfiy the qualifiers FOR BOTH the tables you are picking
data from in the where clause :
For Example :
as you said lets co
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
