If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
query help
access 2003:
I need to get to tableC from tableA and TableB. I tried hard to get to TableC but had no luck. tableA: ID N1 N2 N3 1 12 A1 B1 2 12 D4 Z1 3 45 V5 S3 4 45 F3 O2 5 10 G3 I2 TableB: ID N1 Y1 20 12 33 21 55 51 22 67 23 23 10 34 result: TableC: ID Y1 N1 N2 N3 1 33 12 A1 B1 2 33 12 D4 Z1 3 45 V5 S3 4 45 F3 O2 5 34 10 G3 I2 so on. -- Message posted via http://www.accessmonster.com |
Thread Tools | |
Display Modes | |
|
|