S
subs
Table I
consignee dcity dstate dzip ocity ostate ozip
A d ak 560 b c 789
B e ck 869 de ef 970
C o lk 970 bh mk 975
table 2
consignee dcity dstate dzip ocity ostate ozip
A d ak 560 bl ct 7891
C o lk 970 bhe mtk 9751
F g mk 1075 hi lt 965
I have two tables as above. I need a query which can list all the
records from both the tables by combining the consignee, dcity, dstate
and dzip fields. I need the data in the following format---- Covering
all the records even if they are absent in one of the tables.------
table 1 table2
consignee dcity dstate dzip ocity ostate ozip ocity
ostate ozip
A d ak 560 b c
789 bl ct 7891
B e ck 869 de ef
970 - - -
C o lk 970 bh mk
975 bhe mtk 9751
F g mk
1075 hi lt
965
Pls help with query- i need the result in the above format.
Thanks much
consignee dcity dstate dzip ocity ostate ozip
A d ak 560 b c 789
B e ck 869 de ef 970
C o lk 970 bh mk 975
table 2
consignee dcity dstate dzip ocity ostate ozip
A d ak 560 bl ct 7891
C o lk 970 bhe mtk 9751
F g mk 1075 hi lt 965
I have two tables as above. I need a query which can list all the
records from both the tables by combining the consignee, dcity, dstate
and dzip fields. I need the data in the following format---- Covering
all the records even if they are absent in one of the tables.------
table 1 table2
consignee dcity dstate dzip ocity ostate ozip ocity
ostate ozip
A d ak 560 b c
789 bl ct 7891
B e ck 869 de ef
970 - - -
C o lk 970 bh mk
975 bhe mtk 9751
F g mk
1075 hi lt
965
Pls help with query- i need the result in the above format.
Thanks much