|
Re: Office tab shows no offices
Posted: 09 Jun 09 7:20 AM
|
Hi Chokri,
You will be missing the address records for your office, these are equal joins.
The following 2 SQL statements will add in blank records for the missing Mailing and Shipping address records for your office:
insert into address (addressid, entityid) select addressid, sitecode from branchoptions where branchoptions.addressid not in
(select addressid from address)
insert into address (addressid, entityid) select shippingid, sitecode from branchoptions where branchoptions.shippingid not in
(select addressid from address)
Cheers,
Steve |
|
|