Access 2003 SQL Syntax error in join message -

-

i new @ coding in sql access 2003 , having problem showing additional column called action shown on tledgers table. recieving syntax error message not sure why?

below code snippet causing issue

from (tdailyentries inner join tdailyentries on tledgers.action = tdailyentries.actionno)

below full code

select distinct tprojects.cc_io projectno, year([datefrom]) & " accrual " & monthname(month([datefrom])) & " - "+[companyname] & " ( "+([lastname]) & ")" [line/item/text], tusers.lastname last_name,  tdailyentries.userid userid,  contractordailyrate dailyrate,  contractordailyhours hours,  round(contractordailyrate / contractordailyhours, 2) hourlyrate, round(sum(tdailyentries.calculateddailyhours), 2) monthlyhours,  round((hourlyrate * monthlyhours), 2) charge,  round(charge+round((charge*0.2),2),2) accruals, tprojects.project project (tdailyentries inner join tdailyentries on tledgers.action = tdailyentries.actionno) (tprojecttype  right join tprojects on tprojecttype.projecttypeid = tprojects.projecttypeid)  right join (textcontractor  right join (ttitle  right join (((tlocation  right join (tdepartments  right join tusers  on tdepartments.deptid = tusers.deptid)  on tlocation.locationid = tusers.locationid)  right join (((tdailyentries  left join tdepartments tdepartments_1  on tdailyentries.deptcharged = tdepartments_1.deptshortname)  left join tactions on tdailyentries.actionno = tactions.actionid)  left join tlookups  on tdailyentries.zone = tlookups.lookupid)  on tusers.userid = tdailyentries.userid)  left join textmain  on tusers.userid = textmain.userid)  on ttitle.titleid = tusers.titleid)  on textcontractor.companyid = textmain.contractorcompany)  on tprojects.projectid = tdailyentries.projectno ttitle.titleid = 37  , month([datefrom]) = monthnum  , day([datefrom]) <21 group tprojects.cc_io, year([datefrom]) & " accrual " & monthname(month([datefrom])) & " - "+[companyname] & " ( "+([lastname]) & ")", tusers.lastname, tdailyentries.userid, textmain.contractordailyrate,  month([datefrom]), textmain.contractordailyhours, tprojects.project;

please see updated code below

select distinct tprojects.cc_io projectno, year([datefrom]) & " accrual " & monthname(month([datefrom])) & " - "+[companyname] & " ( "+([lastname]) & ")" [line/item/text], tusers.lastname last_name,  tdailyentries.userid userid,  contractordailyrate dailyrate,  contractordailyhours hours,  round(contractordailyrate / contractordailyhours, 2) hourlyrate, round(sum(tdailyentries.calculateddailyhours), 2) monthlyhours,  round((hourlyrate * monthlyhours), 2) charge,  round(charge+round((charge*0.2),2),2) accruals, tprojects.project project (tdailyentries inner join tledgers  on tledgers.action = tdailyentries.actionno) (tprojecttype  right join tprojects on tprojecttype.projecttypeid = tprojects.projecttypeid)  right join (textcontractor  right join (ttitle  right join (((tlocation  right join (tdepartments  right join tusers  on tdepartments.deptid = tusers.deptid)  on tlocation.locationid = tusers.locationid)  right join (((tdailyentries  left join tdepartments tdepartments_1  on tdailyentries.deptcharged = tdepartments_1.deptshortname)  left join tactions on tdailyentries.actionno = tactions.actionid)  left join tlookups  on tdailyentries.zone = tlookups.lookupid)  on tusers.userid = tdailyentries.userid)  left join textmain  on tusers.userid = textmain.userid)  on ttitle.titleid = tusers.titleid)  on textcontractor.companyid = textmain.contractorcompany)  on tprojects.projectid = tdailyentries.projectno ttitle.titleid = 37  , month([datefrom]) = monthnum  , day([datefrom]) <21 group tprojects.cc_io, year([datefrom]) & " accrual " & monthname(month([datefrom])) & " - "+[companyname] & " ( "+([lastname]) & ")", tusers.lastname, tdailyentries.userid, textmain.contractordailyrate,  month([datefrom]), textmain.contractordailyhours, tprojects.project;

updated code 2

select distinct tprojects.cc_io projectno, year([datefrom]) & " accrual " & monthname(month([datefrom])) & " - "+[companyname] & " ( "+([lastname]) & ")" [line/item/text], tusers.lastname last_name,  tdailyentries.userid userid,  contractordailyrate dailyrate,  contractordailyhours hours,  round(contractordailyrate / contractordailyhours, 2) hourlyrate, round(sum(tdailyentries.calculateddailyhours), 2) monthlyhours,  round((hourlyrate * monthlyhours), 2) charge,  round(charge+round((charge*0.2),2),2) accruals, tprojects.project project (tdailyentries inner join tledgers on tledgers.action = tdailyentries.actionno) inner join (tprojects on tprojecttype.projecttypeid = tprojects.projecttypeid right join (textcontractor  right join (ttitle  right join (((tlocation  right join (tdepartments  right join tusers  on tdepartments.deptid = tusers.deptid)  on tlocation.locationid = tusers.locationid)  right join (((tdailyentries  left join tdepartments tdepartments_1  on tdailyentries.deptcharged = tdepartments_1.deptshortname)  left join tactions on tdailyentries.actionno = tactions.actionid)  left join tlookups  on tdailyentries.zone = tlookups.lookupid)  on tusers.userid = tdailyentries.userid)  left join textmain  on tusers.userid = textmain.userid)  on ttitle.titleid = tusers.titleid)  on textcontractor.companyid = textmain.contractorcompany)  on tprojects.projectid = tdailyentries.projectno ttitle.titleid = 37  , month([datefrom]) = monthnum  , day([datefrom]) <21 group tprojects.cc_io, year([datefrom]) & " accrual " & monthname(month([datefrom])) & " - "+[companyname] & " ( "+([lastname]) & ")", tusers.lastname, tdailyentries.userid, textmain.contractordailyrate,  month([datefrom]), textmain.contractordailyhours, tprojects.project;

that join operation wrong cause depicts doing self join on tdailyentries join on condition contradicts since trying match tledgers.action. believe meant do

..... tdailyentries inner join tledgers  on tledgers.action = tdailyentries.actionno

per comment:

you have 2 from clause in query below

from (tdailyentries inner join tdailyentries on tledgers.action = tdailyentries.actionno) (tprojecttype

change to

from tdailyentries inner join tledgers on tledgers.action = tdailyentries.actionno inner join tprojecttype on ...

Comments

Post a Comment

Popular posts from this blog

matlab - "Contour not rendered for non-finite ZData" -

-
i'm trying plot frequency characteristic equation using ezplot, matlab gives following warning, "contour not rendered non-finite zdata". have used command plot frequency equations warning , plot display empty , not change axis range well. can please help. appreciated. here's code i'm using. % transfer matrix case-i, thin rotor clear all; clc; ei = 1626; l = 0.15; m = 0.44108; = 2.178*10^-4; i_p = 2.205*10^-5; itr = 0.24; i_pr = 0.479; syms p n; f = [1 l*1i l^2/(2*ei)*1i l^3/(6*ei); 0 1 l/ei -l^2/(2*ei)*1i; 0 0 1 -l*1i; 0 0 0 l]; p = [ 1 0 0 0; 0 1 0 0; 0 -it*p^2+i_p*n*p 1 0; -m*p^2 0 0 1]; p_r = [1 0 0 0; 0 1 0 0; 0 -itr*p^2+i_pr*n*p 1 0; -m*p^2 0 0 1]; = f*p*f*p*f*p*f; b = p_r*f*p*f*p*f; r = a(1,2)/a(1,4); a12_p = 0; a22_p = a(2,2)-r*a(2,4); a32_p = a(3,2)-r*a(3,4); a42_p = a(4,2)-r*a(4,4); ap(2,2) = a22_p; ap(3,2) = a32_p; ap(4,2) = a42_p; ap(4,4) = 1; c = b*ap; m = [c(3,2) c(3,4); c(4,2) c(4,...
Read more

delphi - Indy UDP Read Contents of Adata -

-
i using indy udp server read string of data. however, not know how work adata parameter. can around converting binary using bytetobin function below , convert hex using bintohex1 . feel stupid , works slow. know how can directly results without 2 conversions? thanks!! here codes: procedure tform1.idudpserver1udpread(athread: tidudplistenerthread; const adata: tidbytes; abinding: tidsockethandle); var buf: tidbytes; buffer: string; data_received: string; begin if bytestostring(adata) <> 'hello' begin buffer := hextostring('00'); setlength(buf, length(buffer)); copytidstring(buffer, buf, 0); abinding.sendto(abinding.peerip, abinding.peerport, buf); data_received := bintohex1(bytetobin(adata[1]) + bytetobin(adata[2]) + bytetobin(adata[3]) + bytetobin(adata[4]) + bytetobin(adata[5]) + bytetobin(adata[6]) + bytetobin(adata[7]) + bytetobin(adata[8]) + bytetobin(adata[9]) + bytetobin(adata[10]) + bytetobin(adata[11...
Read more

javascript - Any ideas when Firefox is likely to implement lengthAdjust and textLength? -

-
any ideas when firefox implement lengthadjust andtextlength?..... working svg application. lengthadjust , textlength working fine in chrome not working in fire fox . <svg viewbox = "0 0 500 300" version = "1.1"> <defs> <path id="s3" d="m 10,90 q 100,15 200,70" /> </defs> <g> <text font-size = "20"> <textpath xlink:href="#s3" textlength="205"> short text</textpath> </text> <use xlink:href="#s3" fill="none" stroke="black" stroke-width="1"/> </g> </svg> this implemented in firefox text elements (not textpath or tspan) in case that's ok though can move attribute text element. <svg viewbox = "0 0 500 300" version = "1.1"> <defs> ...
Read more