SQL-Ledger Homepage

SQL-Ledger User Forum

Forum index page

Log in | Register

Back to the forum
Board view  Mix view

How is the shipto table related to the customer table (General)

posted by Gregory West(R) E-mail, Manitoba Canada, 09.03.2016, 09:58

I have to write a quick query based on the ship to address, to find out who the ultimate customer was. My problem is I am having trouble figuring out how the shipto table relates to the customer table. ie: If I have a child shipto record, how do I know who the parent record is?

Anyone have an idea how this is set up?

Gregory A. West

---
Gregory A. West
DB&W Systems Limited

 

Complete thread:

Back to the forum
Board view  Mix view
964 Postings in 318 Threads, 323 registered users, 168 users online (0 registered, 168 guests)
SQL-Ledger User Forum | Admin contact
RSS-Feed
powered by my little forum