How to join 2 tables, row by row.

  • Thread starter Thread starter Albert
  • Start date Start date
A

Albert

I'ld like to join 2 table row by row. Both table have the same number of
record but doesn't have any key/unique key for relation. Their relation are
on the order of record. The following is a sample.

Table 1 :
AA
BB
BB
CC

Table 2:
XX
XX
YY
ZZ

Joining Result :
AA,XX
BB,XX
BB,YY
CC,ZZ

What SQL statement for this requirement ?

Regards
 
I'ld like to join 2 table row by row. Both table have the same number of
record but doesn't have any key/unique key for relation.
Click to expand...

Then they are not tables. They're spreadsheets at best.
Their relation are
on the order of record. The following is a sample.
Click to expand...

Access tables HAVE NO ORDER. They are unordered "buckets" of date;
this is in accordance with relational database theory and is true of
most relational database systems.
What SQL statement for this requirement ?
Click to expand...

There is none. You'll need to either copy and paste the data to Excel,
or write a VBA function to open two recordsets and loop through them.
Bear in mind that Access will store new records wherever there is
room; it is *not* necessarily the case that the records are stored in
the same order in which they were entered. Good luck; you'll need it!
 
Back
Top