sql - ORA-00904 "Invalid identifier” for an identifier in a group by clause -

-

I am trying to show ro with compiere database

between two dates.

Column:

Designation

Sales of a Client Sales (Depot) Clients

Quality-Sale Selling Deliver Sales

- Total

Why is this query 

  Designed as SELECT p.name, p.M_PRODUCT_CATEGORY_ID, IL.PRICEACTUAL forms of value In the case of bp.C_BPARTNER_ID idpartner, this is the case when i.IsReturnTrx = 'N' then yoga (il.linenetamt) and yoga (il.linenetamt) * - 1 is the case as the netHT, when i.IsReturnTrx = 'N' then yoga (il.linenetamt + (il.linenetamt * t.rate / 100)) and yoga (il.linenetamt + (il.linenetamt * t.rate / 100)) * - 1 end netTTC In the form of , Qtydepot as (from il.qtyinvoiced selection C_InvoiceLine il ou bp.ISCUSTOMER = 'y' and bp.ISACTIVE = 'y' and bp.C_BPARTNER_ID = 19999), (qtyinvoiced from C_InvoiceLine il ou bp.ISCUSTOMER = 'y' Selection and bp.C_BPARTNER_ID = 18,888) qtyliv, org.description ORGNAME, loc2.address1, loc2.address2, loc2.address3, loc2.address4, loc2.city, loc2.postal, oi.phone, oi.phone2 In the form, Oi. Fax, i.DATEINVOICED from C_InvoiceLine il INNER JOIN M_PRODUCT p ON (p.M_PRODUCT_ID = IL.M_PRODUCT_ID) INNER JOIN at C_INVOICE I. (i.C_INVOICE_ID = IL.C_INVOICE_ID) INNER JOIN C_BPARTNER BP ON (BP C_BPARTNER_ID = I C_BPARTNER_ID) INNER JOIN AD_Org org ON (i.AD_Org_ID = org.AD_Org_ID) Join INNER Join the C_Tax T (T.T.T.M.T.I.L. CTMX_ID) INNER ad_orginfo oi ON (org. Ad_org_id = oi.ad_org_id) Join INNER c_location loc2 ON (oi.c_location_id = loc2.c_location_id) ('Co.', 'CL') - and i.IsSoTrx $ P {DATE1} and $ P {DATE2} - Between- and --i.DocStatus --WHERE i.DateInvoiced = 'Y' - and p.name, p.M_PRODUCT_CATEGORY_ID, il.QTYINVOICED, il.PRICEACTUAL, i.DAT by p.isstocked = EINVOICED, bp.C_BPARTNER_ID, org.description, loc2.address1, loc2 'Y' Group Address II, loc2.address3, loc2.address4, loc2.city, loc2.postal, oi.phone, oi.phone2, oi.fax, i.IsReturnTrx, i.dateinvoiced, qtyliv, p.name order qtydepot, i. Dateinvoiced;

Give me this error: 

  ORA-00904: "QTYLIV": identifier non violet 00 9 04. 00000 - "% s: invalid identifier" * Cause: * Action: Error LaLanne 75, Colon 3

Not your reference For a column nickname in the same level of SQL, except for order section

:

You can use a column Surname, c_alias , to immediately label the preceding expression in the selection list so that the call To be displayed with a new title. The selection list item effectively renames the list for the duration of the alias query. Alias ​​can be used in the ORDER BY section, but none in the query .

When you evaluate the selection list of GROUP BY in QTYLIV , the evaluation has not been evaluated yet and the surname is not present. It only parses and executes the query.

When you have a complex expression in the selection list, it is often easy to wrap in the outer selection and then grouping: 

 choose  (Design as p.name, p.M_PRODUCT_CATEGORY_ID, as the IL.PRICEACTUAL pricing, as bp.C_BPARTNER_ID idpartner, select the case ... (C_InvoiceLine il ou bp.ISCUSTOMER = 'Y' and BP Qtyinvoiced selection as qtyliv, as qtyliv, ... i.DATEINVOICED C_InvoiceLine il join DAT from M_PRODUCT P ... at (oi.c_location_id = loc2.c_location_id) --WHERE i.Da Name, M_PRODUCT_CATEGORY_ID, in the QTYINVOICED group, between teInvoiced $ P {DATE1} and $ P ('Co.', 'CL') - and i.IsSoTrx = 'Y' - and p.isstocked = 'Y') DATE2} - and --i.DocStatus, good luck, ... qtyliv, qtydepot command, name, date of departure;

Note that you do not use the original table aliens in the external selection in GROUP BY or ORDER BY Are not in


Comments

Post a Comment

Popular posts from this blog

java - org.apache.http.ProtocolException: Target host is not specified -

-
I have written a simple httprequest / response code and I am getting this error below: I used to type in my classpath httpclient, httpcore, common -Codecs and general logging. I am very new to Java and I do not know what's going on here. Please help me. code: import org.apache.http.client.HttpClient; Import org.apache.http.client.methods.HttpGet; Import org.apache.http.HttpResponse; Import org.apache.http.impl.client.HttpClientBuilder; Import org.apache.http.Header; Import org.apache.http.HttpHeaders; Public class UnshorteningUrl {public static zero main (string [] args throws exception {HttpGet request = zero; HTTP Client Client = HTTP ClientBuilder.credit (). Build (); Try {Request = New HTTP Gate ("trib.me/1lBFzSi"); HttpResponse httpResponse = client.execute (request); Header [] header = httpResponse.getHeaders (HttpHeaders.LOCATION); // Preconditions.checkState (headers.length == 1); String new url = header [0] .getValue (); System.out.println ("new url...
Read more

java - Gradle dependencies: compile project by relative path -

-
Is it possible to specify a dependency on another gradeal project in the granular (in android studios) outside the current project limits? For example, with a relative path like this: dependence {collection project ('../../ stdlib / dagger'}} MyApp (path / user / foo / workspace / mypad) The app (Path / User / Foo / Workspace / MyPass / App) And I have an Android Library Project with 3 subdomules: stdlib (path is / user / foo / Utilities (Path / User / Foo / Workspace / Stadlib / Utilis) http (Path / User / Foo / Workspace / Stadlib / HT) / Li> What I have to do is compile the Dagger, Util, http module in the MyApp project. The Stidelib Library module under heavy development And MyApp will grow in the form of Growth, so I do not want to push them into a Mewen repository. I am a little change. is likely to add another Gredle projects in some way? I will push the study library into the Maven repository after the source is in search of a temp...
Read more

ruby on rails - Object doesn't support #inspect when used with .include -

-
So I have participated in a glitch error that I do not even know how to debug. I am very new to the railing, so it has kicked my ass well when I use the .includes (school) seen by the student, it gives a blue box error, But when I look at any other model and .includes (school) , the school works just fine. class student & lt; ActiveRecord :: Base has has_many: relationships, foreign_key: "liker_id", dependent :: has_many: matches, foreign_key: "student_1_id", dependent :: deleted belong_to: school belong_to: conference belong_to: would_you_rather belong_to: home city belong_to: year is_to: Major and class school & lt; on the console activatecord :: Affiliate for the base: conference includes: respondent, class: "school", foreign_key: "rival_id" (e.g. For: School) Select SQL generated Select "School". * "School" from "school" "ID" IN (1) error message back NoMethodError: u...
Read more