The features to be implemented when doing a report:
Invoice Home Table A A customer number A.Identity Another table customer contact method B table, the same customer may have a lot of contact methods, or there is no Method_Default if true; then take this contact method, otherwise the contact method is empty;
A. Invoiceno A.Identity 1001 kh0011002 kh0011003 kh0021004 kh003
B.CUSTOMER_ID B.METHOD_DEFAULT B.VALUEKH001 TRUE 0512-123456789KH001 FALSE 0512-987654321KH001 FALSE 0512-999999 KH003 False 0512-88888888
=> Last effect: a.invoiceno a.Identity B.Value1001 kh001 0512-1234567891002 kh001 0512-1234567891003 kh002 1004 kh003
SQL statement: - Customer Contact Method A.IDENTITY = B.CUSTOMER_ID ( ) And B.Method_Default ( ) = 'True'
- Note: If you have one ( ), you can't. I started with the following, the information came out and didn't correct A.Identity = B.CUSTOMER_ID ( ) and b.Method_Default = 'true'
I know it is not difficult, I don't know if it is difficult.