Help realize the task There is a table "Advertising". The Category field comes or in the form of iab format codes., Or in the form of text.
|2||Video||IAB25 Non-Standard Content|
|2||Video||IAB26-1 illegal Content|
There is also a "Directory" table
I need to calculate creative creatives for each category, but at the same time that the codes (IAB ...) are replaced with the values from reference books. I tried to john the directory with the table and group the codes, but then everything that does not fall into the directory has the value of NULL.
For greater clarity. In the Name field, the values from reference books. I make a grouping and get at the exit.
and instead of those values that I miss in the directory I get NULL.
at the output I want to get such a result, where instead of IAB codes ... will be the corresponding values from the reference books
Create Table Content (ID INT, TYPE VARCHAR (255), Category Varchar (255), Category_Value Varchar (255)); INSERT INTO CONTENT VALUES (1, 'picture', 'IAB25', 'coupe'), (2, 'video', 'social', ''), (2, 'video', 'IAB25-1', 'Convertible'), (2, 'video', 'books', ''), (2, 'video', 'IAB25', 'coupe');
How to group such a result?
and not such
- python - you may need to restart the kernel to use updated packages error
- php - coincheck api authentication doesn't work
- php - i would like to introduce the coincheck api so that i can make payments with bitcoin on my ec site
- [php] i want to get account information using coincheck api
- the emulator process for avd pixel_2_api_29 was killed occurred when the android studio emulator was started, so i would like to
- dart - flutter: the instance member'stars' can't be accessed in an initializer error
- i want to call a child component method from a parent in vuejs
- python 3x - typeerror: 'method' object is not subscriptable
- sh - 'apt-get' is not recognized as an internal or external command, operable program or batch file