Similar data

M

Matt Dawson

Does anyone know how i bring out matching fields from different tables within
a query? i.e. Serial ID from one table and match it to that in another?
Many Thanks,
Matt
 
D

Danyx

Let's suppose the following scenario:

You have a table 'table1' with SerialID field (set as primary key) and a
second table 'table2' containing a SerialID field wich is the correspondent
for the SerialID from 'table1'. Next use the following SQL

SELECT table1.field1, table1.field2, ..., table2.field1, table2.field2, ...
FROM table1 INNER JOIN table2 ON table1.SerialID = table2.SerialID;

I hope it will be usefull for you !
 
M

Matt Dawson

sorry i didnt phrase my enquiry well!
Serial ID is not a primary key as several people can own the same machine.
When a quote is given the user checks the box to confirm this! However, to
ensure that the user has not just clicked this without sending a quote, I
need to compare the data against the actual records dragged from another
system. So in theory the checked box should match the sent quote data from
the other system i.e. Time, user etc
Does that make sense?
Matt
 
Top