collecting and combining across tables
Hell, I'm still learning, but this is really giving me issues.
1) OK Table 1 has 49-50 fields of data, I want to exclude/remove 5 of these fields. Note the first field is the ID number to reference between files. About 250,000 lines of data so far.
Example: (6 of the fields)
1069 DAN 1 (nul) 10
1069 DAN 1 (nul) +001875 1140
1355 MAR 1 (nul) +009578 2980
2) This is Table 2 and I want to insert the 2nd and 3rd fields into the data in (1) matching the first field ID.
Example:
1069 Toronto, ON M2J 4V8
1167 Calgary, AB T3E 0G6
1206 Moncton, NB E1C 6X1
1355 Vancouver, BC V6G 2P1
1077 Sarnia, ON N7T 7H3
1315 Brackendale, BC V0N 1H0
3)The desired result is like this so that I can export to CVS.
Example:
1069 Toronto, ON M2J 4V8 DAN 1 (nul) 10
1069 Toronto, ON M2J 4V8 DAN 1 (nul) +001875 1140
1355 Vancouver, BC V6G 2P1 MAR 1 (nul) +009578 2980
I'd appreciate any direction and thank you.
Jason