473,394 Members | 1,889 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,394 software developers and data experts.

Ora 00933 error

1
ora 00933 error arrived while executing these query

Expand|Select|Wrap|Line Numbers
  1. select Hr_department_name,milestone_name,Discription,active_flag from xxpa_project_milestones 
  2. where hr_sm_department_mst.department_Id= xxpa_project_milestones.department_Id groupBy department_id;
I have Two table hr_sm_department_mst consist of table name and another one xxpa_project_milestones which doesnt consist departmentName i have to make join but it shows me these error so can any one sort me out from these error whats wrong with the Query
Oct 7 '11 #1
1 2369
Rabbit
12,516 Expert Mod 8TB
There are a few problems.

Your active_flag field has a space in there. Your group by clause has no space. You refer to a table/view named hr_sm_department_mst that is not in your from clause.
Oct 7 '11 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

13
by: deko | last post by:
I use this convention frequently: Exit_Here: Exit Sub HandleErr: Select Case Err.Number Case 3163 Resume Next Case 3376 Resume Next
7
by: p | last post by:
WE had a Crystal 8 WebApp using vs 2002 which we upgraded to VS2003. I also have Crystal 9 pro on my development machine. The web app runs fine on my dev machine but am having problems deploying....
2
by: f rom | last post by:
----- Forwarded Message ---- From: Josiah Carlson <jcarlson@uci.edu> To: f rom <etaoinbe@yahoo.com>; wxpython-users@lists.wxwidgets.org Sent: Monday, December 4, 2006 10:03:28 PM Subject: Re: ...
2
by: Sahar Madahian | last post by:
Hi! I try to insert value to a table column but I'v got this error 'ORA-00933: SQL command not properly ended' Can anyone help me please? insert into SHAMROCK.CAT_SALESPRODUCT...
4
by: narenshines | last post by:
Hi I am trying to update my table using this.. update tablename set sqlquery = 'select max(upd_rows) from tablename where data_center='***' and tab_abbrev='***'' where userid='12345'; ...
2
by: SREESHAK | last post by:
i am getting the erroe ORA:00933 sql command not properly ended ,for sqlStatement.executeUpdate( "INSERT INTO CLARITY.Z_INBOUND_AUTO_SCHEDULE(FILE_NAME, FILE_DATE, CREATED_DATE, MODIFIED_DATE,...
2
hyperpau
by: hyperpau | last post by:
Before anything else, I am not a very technical expert when it comes to VBA coding. I learned most of what I know by the excellent Access/VBA forum from bytes.com (formerly thescripts.com). Ergo, I...
0
hyperpau
by: hyperpau | last post by:
Before anything else, I am not a very technical expert when it comes to VBA coding. I learned most of what I know by the excellent Access/VBA forum from bytes.com (formerly thescripts.com). Ergo, I...
5
by: yashu0209 | last post by:
I have an error occurring when i try to compile the program and the error is: D:\Program Files\visual studio 6.0\MSDev98\MyProjects\GLEnabledView\GLNew.cpp(164) : error C2653: 'CGLEnabledView' :...
1
by: Haithem Souala | last post by:
create or replace PROCEDURE affich(NMCLI IN NUMBER , STARTDATE IN DATE , ENDATE IN DATE,c out sys_refcursor)IS BEGIN OPEN C FOR SELECT FO.NUMFOUR, FO.RAISONSOCIAL, F.NUMFACTURE, ...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.