sql - INNER JOIN in a long query? -


i landed @ new job , there´s report i´m asked show information stored in table, need enhance existing query developed left company.

the query long , i´m not getting should insert inner join clause retrieve information need.

this original code:

    select toollists.ident,        toollists.descript tldescript,        toollists.materialnr,        toollists.order,        toollists.who,        toollists.ncp,        toollists.rem tlrem,        toollists.mdate,        toollists.tdate,        toollists.gdate,        toollist.t,        machines.name machinename,        machines.trelation,        toollist.d,        toollist.h,        toollist.pos toollistpos,        toollist.rem toollistrem,        toollist.how toollisthow,        tools.nr,        tools.z1,        tools.drawing,        tools.x1,        tools.sort,        tools.design,        tools.descript,        tools.rem toolrem,        toolparts.pos toolpartpos,        toolparts.nbr,        toolparts.how,        parts.unr,        parts.mid,        parts.descript,        parts.sort,        parts.design,        parts.urem,        parts.dmc,        parts.clength,        parts.cmainarc,        parts.cradius,        parts.uactiv,        matclasses.dmc,        matclasses.description,        matclasses.quality,        notetoollists.notetext parts inner join ( (machines               right join ( (matclasses                             right join (notetoollists                                         right join (materials                                                     right join ([select id, param1 wtdidlist wtguid = '4a9b5a05-fa43-48d1-af2f-342ea407f4e2']. idlist                                                                 inner join toollists on idlist.id = toollists.nr) on materials.nr = toollists.materialnr) on notetoollists.nr = toollists.nr) on matclasses.nr = materials.matclassnr)                           inner join (tools                                       inner join toollist on tools.nr = toollist.toolnr) on toollists.nr = toollist.toollistnr) on machines.nr = toollists.machinenr)             inner join toolparts on tools.nr = toolparts.toolnr) on parts.id = toolparts.partid order toollists.nr,          toollist.pos,          toollist.t;

there´s table called siteparts containing column named place - need retrieve value in column value of column partid equal column idin table parts

so tried add code above:

inner join (select place siteparts) on siteparts.partid = parts.id

so attempt:

 select toollists.ident,            toollists.descript tldescript,            toollists.materialnr,            toollists.order,            toollists.who,            toollists.ncp,            toollists.rem tlrem,            toollists.mdate,            toollists.tdate,            toollists.gdate,            toollist.t,            machines.name machinename,            machines.trelation,            toollist.d,            toollist.h,            toollist.pos toollistpos,            toollist.rem toollistrem,            toollist.how toollisthow,            tools.nr,            tools.z1,            tools.drawing,            tools.x1,            tools.sort,            tools.design,            tools.descript,            tools.rem toolrem,            toolparts.pos toolpartpos,            toolparts.nbr,            toolparts.how,            parts.unr,            parts.mid,            parts.descript,            parts.sort,            parts.design,            parts.urem,            parts.dmc,            parts.clength,            parts.cmainarc,            parts.cradius,            parts.uactiv,            matclasses.dmc,            matclasses.description,            matclasses.quality,            notetoollists.notetext,            siteparts.place     parts     inner join ( (machines                   right join ( (matclasses                                 right join (notetoollists                                             right join (materials                                                         right join ([select id, param1 wtdidlist wtguid = '4a9b5a05-fa43-48d1-af2f-342ea407f4e2']. idlist                                                                     inner join toollists on idlist.id = toollists.nr)                                                         inner join                                                           (select place                                                            siteparts)) on materials.nr = toollists.materialnr) on notetoollists.nr = toollists.nr) on matclasses.nr = materials.matclassnr)                   inner join (tools                               inner join toollist on tools.nr = toollist.toolnr) on toollists.nr = toollist.toollistnr) on machines.nr = toollists.machinenr)     inner join toolparts on tools.nr = toolparts.toolnr) on parts.id = toolparts.partid on partid = parts.id     order toollists.nr,              toollist.pos,              toollist.t;

but server rejecting query, following message:

msg 156, level 15, state 1, line 1 incorrect syntax near keyword 'order'. msg 102, level 15, state 1, line 9 incorrect syntax near ')'.

i have revisited bunch of times i´m not being able handle long query correctly. can point me i´m doing wrong?

it´s obvious i´m not in sql previous guy, need catch , try make things work current code rather re-write because don´t how made it.

even though query quite complex , use rewriting, answer should quite simple.

add select-part:

siteparts.place

... did in attempt (with comma between entry , previous/next entries).

then add in new line above order by-line:

inner join siteparts on siteparts.partid = parts.id

that should it.


Comments

Post a Comment

Popular posts from this blog

php - How to add and update images or image url in Volusion using Volusion API -

actually have store importing products store product data insert , update image or image url not insert , update. this xml code name datapro.txt. <products_joined> <productcode>3710_012t</productcode> <vendor_partno>eah5450silent/di/1gd3(lp)</vendor_partno> <productname>test product ta</productname> <hideproduct>n</hideproduct> <stockstatus>20</stockstatus> <lastmodified>1/5/2016 10:25:00 am</lastmodified> <lastmodby>2</lastmodby> <productweight>0.9</productweight> <productprice>100</productprice> <productmanufacturer>asus tek</productmanufacturer> <vendor_price>32.69</vendor_price> <numproductssharingstock>0</numproductssharingstock> <categoryids>107</categoryids> <producturl>http://tebkq.mvlce.servertrust.com/productdetails.asp?productcode=3710_012t</producturl...
Read more

Laravel mail error `Swift_TransportException in StreamBuffer.php line 269: Connection could not be established with host smtp.gmail.com [ #0]` -

i developing website contact-us page guest users can send me email using gmail . anytime try send mail using contact-us form, error swift_transportexception in streambuffer.php line 269: connection not established host smtp.gmail.com [ #0] this mail.php return [ 'driver' => env('mail_driver', 'smtp'), 'host' => env('mail_host', 'smtp.gmail.com'), 'port' => 587, 'from' => ['address' => '', 'name' => ''], 'encryption' => env('mail_encryption', 'tls'), 'username' => env('mail_username'), 'password' => env(mail_password), 'sendmail' => '/usr/sbin/sendmail -bs', 'pretend' => env('mail_pretend', false), ]; this .env mail_driver=smtp mail_host=smtp.gmail.com mail_port=587 mail_username=afecjaped@gmail.com mail_password=********...
Read more

c# SetCompatibleTextRenderingDefault must be called before the first -

i tried search exception couldn't find solution on case i'am using code below invoke .net application : assembly assem = assembly.load(data); methodinfo method = assem.entrypoint; var o = activator.createinstance(method.declaringtype); method.invoke(o, null); the application invoked has form , in entrypoint of application : [stathread] static void main() { application.enablevisualstyles(); application.setcompatibletextrenderingdefault(false); //exception application.run(new form1()); } setcompatibletextrenderingdefault must called before first iwin32window object created in application. edit : assembly = assembly.load(data); methodinfo method = a.gettype().getmethod("start"); var o = activator.createinstance(method.declaringtype); method.invoke(o, null); you should create new method skips initialization...
Read more