shiptoquery
no way to compare when less than two revisions
Differences
This shows you the differences between two versions of the page.
— | shiptoquery [2015/09/21 16:34 (9 years ago)] (current) – created cparagoso | ||
---|---|---|---|
Line 1: | Line 1: | ||
+ | There could be instances wherein a customer would like to be able to generate a Customer Report with their 'Ship To Addresses' | ||
+ | Note: The customer must be very knowledgeable about SQL databases and we must also have our programmers' | ||
+ | |||
+ | |||
+ | **SELECT c.RecordNo, a.Name, c.Comment FROM Comment c INNER JOIN Account a ON AUnique=RecordNo WHERE FileNo=99 ORDER BY c.RecordNo, c.LineNo;** | ||
+ | |||
+ | |||
+ | |||
+ | |||
+ | FileNo 99 is where the Ship To Addresses are stored. After running this query, the ' |
shiptoquery.txt · Last modified: 2015/09/21 16:34 (9 years ago) by cparagoso