Home » Other » Training & Certification » please help
please help [message #344664] Sun, 31 August 2008 15:38 Go to next message
kim_SQL
Messages: 2
Registered: August 2008
Junior Member
List the agents that accessed the information system. Do not use equality sign in your condition.The query should return the AGENT_ID, INFORMATION_ID and GLEANED_DATE.
DROP TABLE ANSW;
CREATE TABLE ANSW
AS
	SELECT
		AGENT_ID,
		INFORMATION_ID
	FROM
		INFO_ACCESS
;
SELECT
	GLEANED_DATE
FROM
	INFORMATION
WHERE
	AGENT_ID IN
	(
	SELECT 
		AGENT_ID
	FROM
		ANSW
	)
;
SELECT
	ANSW.AGENT_ID,
	ANSW.INFORMATION_ID,
	INFORMATION.GLEANED_DATE
FROM
	ANSW
INNER JOIN
	INFORMATION
USING
	(AGENT_ID)
;

Could not get the answer.
Please help!

[Edit MC: add code tags, do it yourself next time]

[Updated on: Sun, 31 August 2008 23:57] by Moderator

Report message to a moderator

Re: please help [message #344669 is a reply to message #344664] Sun, 31 August 2008 20:33 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
http://www.orafaq.com/forum/t/88153/0/
Please read & FOLLOW the Posting Guidelines as stated in URL above
Previous Topic: master detail query
Next Topic: Certification: Oracle9i or Oracle10g
Goto Forum:
  


Current Time: Fri Mar 29 08:04:20 CDT 2024