join - What is wrong with my MySQL query (UNION)? -

-

i hope can me here. i'm working on pms system , want run simple select statement list of secret codes customers based on of parcels have arrived , transaction type. 'transferconfirmation' table has customer id , secret code , displays 1 row each instance reason, when use following query:

select `tc`.`transferid` `transferid`,        `c`.`firstname` `firstname`,        `c`.`lastname` `lastname`,        `tc`.`secretcode` `secretcode`,        'purchase order' `transactiontype` (((((`db`.`transferconfirmation` `tc`           join `db`.`customer` `c` on((`tc`.`customerid` = `c`.`customerid`)))          join `db`.`transfer` `t` on((`t`.`transferid` = `tc`.`transferid`)))         join `db`.`transferentry` `te` on((`t`.`transferid` = `te`.`transferid`)))        join `db`.`purchaseorder` `po` on((`te`.`referenceid` = `po`.`purchaseorderid`)))       join `db`.`purchaseorderentry` `poe` on(((`po`.`purchaseorderid` = `poe`.`purchaseorderid`)                                                , (`te`.`referenceentryid` = `poe`.`purchaseorderentryid`)))) (`poe`.`collectionstatus` = 0) union select `tc`.`transferid` `transferid`,        `c`.`firstname` `firstname`,        `c`.`lastname` `lastname`,        `tc`.`secretcode` `secretcode`,        'shipping order' `transactiontype` (((((`db`.`transferconfirmation` `tc`           join `db`.`customer` `c` on((`tc`.`customerid` = `c`.`customerid`)))          join `db`.`transfer` `t` on((`t`.`transferid` = `tc`.`transferid`)))         join `db`.`transferentry` `te` on((`t`.`transferid` = `te`.`transferid`)))        join `db`.`shippingorder` `so` on((`te`.`referenceid` = `so`.`shippingorderid`)))       join `db`.`shippingorderentry` `soe` on(((`so`.`shippingorderid` = `soe`.`shippingorderid`)                                                , (`te`.`referenceentryid` = `soe`.`shippingorderentryid`)))) (`soe`.`collectionstatus` = 0)

i keep getting results duplicate data difference transaction. guess question is, if secret code has been selected once, how prevent other row displaying same code.

use union operator. union operator remove duplicate records each query (union all retain them).

select transferid, firstname, lastname, secretcode,     'purchase order' transactiontype ... union select transferid, firstname, lastname, secretcode,     'purchase order' transactiontype ...

Comments

Post a Comment

Popular posts from this blog

sql - VB.NET Operand type clash: date is incompatible with int error -

-
i trying display records table named staffpresentee database using clause... i using visual studio 2010... the table design follows- .......fieldname..................datatype........allownull 1......staff_id (fk).............numeric(18,0)......yes 2.......date........................date.............no 3......present.....................char(1)..........yes note type of 2nd field date , not datetime... i want display records table have today's date int 'date' field... current query is- cmd = new sqlclient.sqlcommand("select * staffpresentee date=" & date.now.date, cn) dr = cmd.executereader for dr = cmd.executereader error "operand type clash: date incompatible int" i tried select * staffpresentee query without clause runs correctly. try putting date value in sigle quotes maybe. cmd = new sqlclient.sqlcommand("select * staffpresentee date='" & _
Read more

SVG stroke-linecap doesn't work for circles in Firefox? -

-
i've got problem svg stroke-linecap attribute. i've got circular progress bar in angularjs , set outer circle (blue one) have rounded "ends". @ fiddle . <svg ... height="130" width="130"> <!-- ngif: background --> <circle ... ng-if="background" fill="#fff" class="ng-scope" stroke-width="13" stroke="#cc3399" r="57.5" cy="65" cx="65" stroke-linecap="round" /> <!-- end ngif: background --> <circle ... fill="none" stroke-dashoffset="36.12831551628261" stroke-dasharray="361.28315516282623" stroke-width="13" stroke="#432db3" stroke-linecap="round" r="57.5" cy="65" cx="65" transform="rotate(-89.9, 65, 65)" /> </svg> how can that?
Read more

python - TypeError: Scalar value for argument 'color' is not numeric in openCV -

-
here code im = cv2.imread('luffy.jpg') gray = cv2.cvtcolor(im,cv2.color_bgr2gray) ret,thresh = cv2.threshold(gray,127,255,0) contours,h = cv2.findcontours(thresh,cv2.retr_tree,cv2.chain_approx_simple) cnt in contours: moment = cv2.moments(cnt) c_y = moment['m10']/(moment['m00']+0.01) c_x = moment['m01']/(moment['m00']+0.01) centroid_color = im[c_x,c_y] centroid_color = np.array((centroid_color[0],centroid_color[1],centroid_color[2])) print type(centroid_color) cv2.fillpoly(im,cnt,centroid_color) i getting error on last line try , pass centroid_color color argument. <type 'numpy.ndarray'> , have been able pass data type cv2.fillpoly color in other instances, not sure why having problem here. fillpoly() expects iterable, i.e. put cnt in brackets. believe duplicate of https://stackoverflow.com/a/17582850/5818240 . moreover, centroid color variable contains strings. need convert them i
Read more