Oracle Special Increasing Practice - Tape Conditions.

zhaozj2021-02-16  83

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.

转载请注明原文地址:https://www.9cbs.com/read-12347.html

New Post(0)