取用户信息

SELECT DISTINCT dbo.Customer.FirstName,dbo.Payment_Info.cardNumber,dbo.Shipping_Info.shippingAddr1
FROM dbo.Shipping_Info,dbo.Payment_Info,dbo.Customer,dbo.Orders,dbo.Order_Item,dbo.Customer_Login
WHERE Orders.OrderId=124889 AND dbo.Customer_Login.username='weihuayan@gmail.com'
AND dbo.Customer_Login.CustomerNumber=dbo.Customer.CustomerNumber AND
dbo.Orders.OrderId=dbo.Order_Item.orderId AND dbo.Order_Item.shippingInfoId=dbo.Shipping_Info.shippingInfoId
AND dbo.Shipping_Info.PaymentInfoID=dbo.Payment_Info.paymentInfoId