Lets say I have the following tables
CUSTOMER_ADDRESS (has Address_Ln_No, City, State, Zip etc.)
CUSTOMER_ADDRESS_LN (has Address_Ln_No, Address_Ln_Text)
Essentially if the customers address was
PO. Box 69 <--- This would take one row in ADDRESS_LN table)
Cigar Road <------- This would take yet another row in ADDRESS_LN table)
New York, NY 10096
I believe whoever created it this way wanted flexibility to add an address
that had several lines.
I need to create a Invoice for Mr. Clinton. How can I create a SQL query
that will take all the address_ln rows using SELECT statement.
Sorry in advance for such a dump question.