In Access or SQL, try to define this query: SELECT [Table 1].[Description From], [Table 1].From, [Table 2].[Description From] as [Description To], [Table 2].From as [To] FROM [Table 1] INNER JOIN [Table 2] ON [Table 1].To = [Table 2].From

How can I have such a result from two tables? With SQL command

Accepted answer

Viorel 113.7K Reputation points

2024-03-12T05:50:40.22+00:00
In Access or SQL, try to define this query:

SELECT [Table 1].[Description From], [Table 1].From, [Table 2].[Description From] as [Description To], [Table 2].From as [To] FROM [Table 1] INNER JOIN [Table 2] ON [Table 1].To = [Table 2].From
Please sign in to rate this answer.
Mansour_Dalir 1,676 Reputation points

2024-03-12T06:27:38.06+00:00

hi Viorel

The number of records in my table is 31280. After answering this question (the previous question), the records were divided into two parts. (15,640) So far everything is correct. But after the result of this answer, the number of records increased from 15640. I mean, I still haven't found the answer. Why?

which should be 15640 records

Viorel 113.7K Reputation points

2024-03-12T11:53:31.7266667+00:00

If the division was correct, probably a table contains rows that correspond to more than one row from another table, and it is not clear how to join your real data.
Sign in to comment

Share via

How can I have such a result from two tables? With SQL command

0 additional answers