sql - Invalid Identifier. Is it the concat code? -

-

i keep getting error "invalid identifier" , know columns right... thoughts?

also, know concat coding kind of messy. offered code it: 

,mp_asin.parent_asin_name || ', ' || mp_asin.color_name teen

which better?

select    mp_asin.category_code category_id     ,mp_asin.subcategory_code subcategory    ,mp_asin.parent_asin    ,mp_asin.parent_asin_name     ,mp_asin.color_name color_name     ,mp_asin.product_site_launch_day psld     ,concat(mp_asin.parent_asin_name, concat(',', concat(' ',mp_asin.color_name))) teen     ,mp.brand_code brand_code     ,mp.replenishment_code replen_code     ,mp.replenishment_category_id replen_tier    ,mp.asin asin    , min(mp.replenishment_code) on (partition (concat(mp_asin.parent_asin_name, concat(',', concat(' ',mp_asin.color_name))))) min_teen_rc    , max(mp.replenishment_code) on (partition (concat(mp_asin.parent_asin_name, concat(',', concat(' ',mp_asin.color_name))))) max_teen_rc  d_mp_asins mp  min_teen_rc <> max_teen_rc , mp.product_category =('30905500')  , mp_asin.subcategory_code =('30905560') , mp.region_id = 1 , mp.marketplace_id = 1 , mp.gl_product_group = 309  group mp_asin.category_code ,mp_asin.subcategory_code  ,mp_asin.parent_asin ,mp_asin.parent_asin_name ,mp_asin.color_name ,mp_asin.product_site_launch_day ,concat(mp_asin.parent_asin_name, concat(',', concat(' ',mp_asin.color_name))) ,mp.brand_code ,mp.replenishment_code ,mp.replenishment_category_id ,mp.asin

i think missed table alias mp_asin. see 1 table in from clause.

this better , more readable:

mp_asin.parent_asin_name || ', ' || mp_asin.color_name teen


Comments

Post a Comment

Popular posts from this blog

c++ - How to add Crypto++ library to Qt project -

-
Image
i downloaded crypto++ source , compiled cryptlib project in visual studio 2013, , added generated .lib file qt project, made .pro file this: qt += core gui qt += sql greaterthan(qt_major_version, 4):qt += widgets target = untitled template = app sources += main.cpp\ mainwindow.cpp headers += mainwindow.h \ databasecontrol.h \ test.h forms += mainwindow.ui win32:config(release, debug|release): libs += -l$$pwd/ -lcryptlib else:win32:config(debug, debug|release): libs += -l$$pwd/ -lcryptlibd else:unix: libs += -l$$pwd/ -lcryptlib includepath += $$pwd/ dependpath += $$pwd/ win32-g++:config(release, debug|release): pre_targetdeps += $$pwd/libcryptlib.a else:win32-g++:config(debug, debug|release): pre_targetdeps += $$pwd/libcryptlibd.a else:win32:!win32-g++:config(release, debug|release): pre_targetdeps += $$pwd/cryptlib.lib else:win32:!win32-g++:config(debug, debug|release): pre_targetdeps += $$pwd/cryptlibd.lib else:unix: pre_targetdeps += $$pw...
Read more

jQuery Mobile app not scrolling in Firefox -

-
i have mobile app built in jquery mobile. scrolling fine in chrome & safari, fails scroll in firefox on desktop. have other instances of same app, different features, , works across browsers. life of me, cannot figure this, please help! located here: http://re-brand.us/dsus/index.html seems bug in firefox: bug log . able scroll using keyboard not trackpad on mac. are using mac? i'll keep looking see if can find way around it.
Read more

how to receive file in java(servlet/jsp) -

-
hi making communication protocol. on web server send 1 file curl(in c# post http request). task been done. how should receive file java on web server gone through this article . file downloading. want receive file java. this link may .. have provide multiprt form data .. http://www.journaldev.com/2122/servlet-3-file-upload-using-multipartconfig-annotation-and-part-interface
Read more