Important Notice from AspDotNetStorefront
It is with dismay that we report that we have been forced, through the action of hackers, to shut off write-access to this forum. We are keen to leave the wealth of material available to you for research. We have opened a new forum from which our community of users can seek help, support and advice from us and from each other. To post a new question to our community, please visit: http://forums.vortx.com
Results 1 to 3 of 3

Thread: addresss table

  1. 08-12-2010, 05:58 PM #1
    qinfu is offline Junior Member
    Join Date
    Jun 2010
    Posts
    10

    Default addresss table

    Can you distinguish the billing address and shipping address in address table? They are same fields without any flag
  2. 08-12-2010, 06:10 PM #2
    qinfu is offline Junior Member
    Join Date
    Jun 2010
    Posts
    10

    Default from scratch

    I want to code to update billing and shipping address from scratch. thanks.
  3. 08-12-2010, 07:35 PM #3
    ASPAlfred is offline Senior Member
    Join Date
    Nov 2007
    Posts
    2,244

    Default

    Quinfu,

    You can determine those by executing the query below:

    Code:
    select distinct BillingAddressId, ShippingAddressId, c.customerid from customer c 
inner join address a on c.customerid = a.customerid