sql - Join two select queries horizontally in Postgresql -

-

i have following 2 queries:

query #1:

(select      pl.c_project_id, pl.c_projectphase_id, pl.c_projecttask_id, pl.m_product_id,     pj.name projectname, ph.name phasename, pt.name taskname, pd.name prodname,     round(pl.plannedqty, 2) planqty, round(pl.plannedprice, 2) planrate,     round(pl.plannedamt, 2) planamt  adempiere.c_projectline pl left join adempiere.c_project pj on pl.c_project_id = pj.c_project_id left join adempiere.c_projectphase ph on pl.c_projectphase_id = ph.c_projectphase_id left join adempiere.c_projecttask pt on pl.c_projecttask_id = pt.c_projecttask_id left join adempiere.m_product pd on pl.m_product_id = pd.m_product_id pl.c_project_id = 1000001 , pl.ad_client_id = 1000000 order ph.c_projectphase_id, pt.c_projecttask_id)

output is: 11 columns , 16 rows

query #2:

(select     fa.c_project_id, fa.c_projectphase_id, fa.c_projecttask_id, fa.m_product_id,     pj.name costprojectname, ph.name costphasename, pt.name costtaskname,     pd.name costprodname,     abs(fa.qty) costqty, round((fa.amtacctdr/fa.qty), 2) costrate,     round(sum(fa.amtacctdr), 0) costamt  adempiere.fact_acct fa left join adempiere.c_project pj on fa.c_project_id = pj.c_project_id left join adempiere.c_projectphase ph on fa.c_projectphase_id = ph.c_projectphase_id left join adempiere.c_projecttask pt on fa.c_projecttask_id = pt.c_projecttask_id left join adempiere.m_product pd on fa.m_product_id = pd.m_product_id  fa.c_project_id = 1000001 , (fa.gl_category_id = 1000006 or fa.gl_category_id = 1000005) , fa.qty > 0 , fa.c_project_id not null group fa.m_product_id, fa.c_project_id, fa.c_projectphase_id, fa.c_projecttask_id,         fa.qty, fa.amtacctdr,         pj.name, ph.name, pt.name, pd.name)

output is: 11 columns , 6 rows

i want join these queries horizontally, display columns rows should not duplicate. when apply union join them result shows duplicate rows. how can cope issue?

you should able join queries this:

select *   (    <your first query here>   ) tbl1   join (     <your second query here>   ) tbl2   on tbl1.c_project_id = tbl2.c_project_id  , tbl1.c_projectphase_id = tbl2.c_projectphase_id -- might add or  , tbl1.c_projecttask_id  = tbl2.c_projecttask_id  -- remove join criteria   , tbl1.m_product_id = tbl2.m_product_id           -- here

Comments

Post a Comment

Popular posts from this blog

java - Plugin org.apache.maven.plugins:maven-install-plugin:2.4 or one of its dependencies could not be resolved -

-
i getting error message , further 1 here: failed read artifact descriptor org.apache.maven.plugins:maven-install-plugin:jar:2.4: even though when go .m2 repository path c:\users\a591024.m2\repository\org\apache\maven\plugins\maven-resources-plugin\2.4 the maven-resources-plugin-2.4.jar file there , maven-resources-plugin-2.4.pom there. have tried delete .m2 repository no luck. far maven not build project desperately need to. any ideas? it seems proxy issue please aad following in setting.xml grabbing lan setting , proxy information. <proxies> <proxy> <id>proxy</id> <active>true</active> <protocol>http</protocol> <host>hostname</host> <port>port</port> </proxy> </proxies> this frequent issue, please see below link well. plugin org.apache.maven.plugins:maven-clean-plugin:2.5 or 1 of dependencies not resolved maven: failed ret...
Read more

Round ImageView Android -

-
Image
i working on android application in doing rounded image view. working fine images, images 160x120 resolution shows oval shaped. code custom imageview given below, please me out here: public class roundimage extends drawable { private final bitmap mbitmap; private final paint mpaint; private final rectf mrectf; private final int mbitmapwidth; private final int mbitmapheight; public roundimage(bitmap bitmap) { mbitmap = bitmap; mrectf = new rectf(); mpaint = new paint(); mpaint.setantialias(true); mpaint.setdither(true); final bitmapshader shader = new bitmapshader(bitmap, shader.tilemode.clamp, shader.tilemode.clamp); mpaint.setshader(shader); mbitmapwidth = mbitmap.getwidth(); mbitmapheight = mbitmap.getheight(); } @override public void draw(canvas canvas) { canvas.drawoval(mrectf, mpaint); } @override protected void onboundschange(rect bound...
Read more

How can I utilize Yahoo Weather API in android -

-
Image
i want develop app using yahoo weather api android. want current , forecast weather details. i have tried different sources (e.g.: https://github.com/survivingwithandroid/weatherlib , getting error weatherlib api android , unable execute activity in android weatherlib ) , getting different errors m unable resplve. there can proper tutorial or guide! error: -17 08:50:48.961 3168-3168/com.survivingwithandroid.weather e/androidruntime﹕ fatal exception: main process: com.survivingwithandroid.weather, pid: 3168 java.lang.runtimeexception: unable start activity componentinfo{com.survivingwithandroid.weather/com.survivingwithandroid.weather.mainactivity}: java.lang.nullpointerexception: attempt invoke interface method 'boolean java.util.list.isempty()' on null object reference @ android.app.activitythread.performlaunchactivity(activitythread.java:2298) @ android.app.activitythread.handlelaunchactivity(activitythread.java:2360) @ android.app.activi...
Read more