OraFAQ Forum: SQL & PL/SQL » Get last record from another table

Home » SQL & PL/SQL » SQL & PL/SQL » Get last record from another table (11g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Get last record from another table [message #670609]

Mon, 16 July 2018 10:50

ritaman
Messages: 10
Registered: September 2011
Location: Ireland

Junior Member

Hi there,
I would really appreciate your help on interrogating my tables.
I want to a list of Material Codes, the last Cost Code used and the Nominal Code associated with that Cost Code.

My 3 tables which I would like to interrogate as follows;
Material_Codes (A)
Material_Code
Category_Code
Material_Description

Unique Key is Material_Code

Material_Cost_Codes (B)
Material_Code
Supplier_Code
Cost_Code
Category_Code
Updated_Date

Unique key is Cost_Code + Supplier_Code + Material_code

Cost_Code (C)
Cost_Code
Cost_Description
Nominal_Code

Unique Key is Cost_Code

I wish to write a query which will list;
A.Material_Code, A.Category_code, A.Material_Description, B.Cost_Code *, C.Cost_Description, C.Nominal_Code

• This is the last Cost_Code used i.e. Latest B.Updated_date for this Material_Code

Hope I have explained this sufficiently.
Thanking you in advance for your help.

Best regards
Rita

Report message to a moderator

[Message index]

		Get last record from another table By: ritaman on Mon, 16 July 2018 10:50
		Re: Get last record from another table By: BlackSwan on Mon, 16 July 2018 11:44
		Re: Get last record from another table By: Michel Cadot on Mon, 16 July 2018 12:28
		Re: Get last record from another table By: ritaman on Tue, 17 July 2018 02:41
		Re: Get last record from another table By: cookiemonster on Tue, 17 July 2018 03:04
		Re: Get last record from another table By: ritaman on Tue, 17 July 2018 03:11
		Re: Get last record from another table By: cookiemonster on Tue, 17 July 2018 04:36
		Re: Get last record from another table By: hiddenTR on Tue, 17 July 2018 07:04
		Re: Get last record from another table By: ritaman on Wed, 18 July 2018 02:54
		Re: Get last record from another table By: Michel Cadot on Wed, 18 July 2018 02:58
		Re: Get last record from another table By: cookiemonster on Wed, 18 July 2018 03:37
		Re: Get last record from another table By: ritaman on Wed, 18 July 2018 04:20
		Re: Get last record from another table By: cookiemonster on Wed, 18 July 2018 04:31
		Re: Get last record from another table By: cookiemonster on Wed, 18 July 2018 04:33
		Re: Get last record from another table By: ritaman on Wed, 18 July 2018 04:53
		Re: Get last record from another table By: cookiemonster on Wed, 18 July 2018 05:11
		Re: Get last record from another table By: ritaman on Wed, 18 July 2018 05:21
		Re: Get last record from another table By: cookiemonster on Wed, 18 July 2018 05:26

Previous Topic:	Need Help on Pl/Sql
Next Topic:	ORA-04091: table Table_Name is mutating, trigger/function may not see it

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed May 01 16:44:33 CDT 2024