A "join" is based on a relationship between two tables, which you don't
have. If you specify a join without describing the relationship (Select *
From Table1, Table2) then you get a cross product, which is every row in one
table paired up with every row in the other table.
AAA 1 CCC 3
AAA 1 DDD 4
BBB 2 CCC 3
BBB 2 DDD 4
Not sure how to get your exact results without tweaking the tables or using
some code.
Quote:
> Hi,
> Is it possible to join two tables so that the number of
> the fields of the result will be the sum of that of the
> two tables? Assume that there is no relationship between
> the two tables and we can retrieve the same rows from two
> tables.
> For example:
> Table1
> AAA 1
> BBB 2
> Table2
> CCC 3
> DDD 4
> Result will be:
> AAA 1 CCC 3
> BBB 2 DDD 4
> This kind of join is neither Inner Join nor Outer Join. I
> have not found a solution.
> Any suggestion and ideas will be greatly appreciated.
> Thanks
> Andy
Join two tables