I have two columns in one table(A1) and another in A2.
A1 A2
------- ---------
abc bcd cde
----- ----- ---------
csdc ghng 34
dfvfd bfgb wer
vcfdcv bgf 65
vdf gfr 567
vg ggrf 575
v yhgr 765
How to join a column in another table (without Join)
Moderators: chulett, rschirm, roy
-
- Charter Member
- Posts: 299
- Joined: Wed Nov 13, 2002 5:38 pm
- Location: USA
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
It is really hard to figure out what he is trying to do. Does he have 2 tables with 1 column each, A1 in table 1 and A2 in table 2? Does he have 2 tables with common primary keys and then a column in each named A1 and A2? If it is the latter, then obviously lookup would be the most appropriate solution.