SQL

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I have two tables im looking at comparing data.
In the first table i have the unique id, name and sales data, in the second
table i have name unique id and other customer data but i also have a the
field type.
What im looking to do is compare the two tables and display the field type
against the relevent customer, is this possible.

Thanks
 
Hi,

If you bring the two tables in the query designer and JOIN the tables
through their "id", can you get your data as you want, dragging the required
fields in the grid?



Hoping it may help,
Vanderghast, Access MVP
 
Hi,

Yeah it help alot, but im not very good with writing querys and the linking,
could you specify how i would do it at all. As you can imagine i have been
staring at this database for the past 7 weeks and for me it doesnt seem like
it is going to end. Are you able to do that at all.
 
Hi,

To join the two tables through a field from each table, which can be
seen as some kind of "lookup",

in the query designer, have the two tables (in the upper part),
from one of the table, drag its involved field and drop it over the field of
the other table.

That will graphically result in a line being drawn between the two tables,
which represents your join, or the "path" that makes the lookup-match
between the two tables.


Hoping it may help,
Vanderghast, Access MVP
 
Back
Top