Hello all,
My name is David and I’m the DBA for the
My question has to do with generating a shipping report for
the registrars. I have the table structures from TMS but I am having
problems getting the joins done in such a way that they are all one to one
relationships. My understanding is that for the report to run from TMS
the joins need to be one to one. I’ve had some email conversations
with the guys in support (Dimitry and Brian) but so far we haven’t been
able to come up with any sort of solution. I’m reaching out to all
of you in hopes that someone out there has already slain this particular
dragon.
I need the following fields…
ObjectNumber
Lender (Constituent first and last name)
Title
Medium
Crate Number
Crate Dimensions
Crate Weight
Value
ShipFrom Geo & Address
ShipTo Geo & Address
I know where all of the fields are. I have joined the
tables together but I get multiple records for each object number. The
“problem” is that many times the objects have been shipped multiple
times, or the objects require multiple crates. Those conditions are
leading to duplicates.
Any suggestions? Any report examples that you can
share? Thanks in advance!
David Armstrong
Database Administrator
MOCA THE