hi,
i have 2 tables: CUST and ORDERS
CUST contains cust_num, cust_name, cust_phone
ORDERS contains cust_num, order_date, order_amt
i want to list all the cust_names and their last order date and amount
how would i code this?
thanks.
alidabiri 0
Newbie Poster
Recommended Answers
Jump to PostUse join to retrive record from both the tables by joining on CUST_NUM field. then use group by.
Jump to PostI am glad to know that you found the solution before i do that for you. Happy programming.
Jump to PostHi,
Combined with lat_upd, You can Select using Order By RowID.. RowID is unique for each row...
Regards
Veena
All 14 Replies
debasisdas 580
Posting Genius Featured Poster
alidabiri 0
Newbie Poster
alidabiri 0
Newbie Poster
alidabiri 0
Newbie Poster
debasisdas 580
Posting Genius Featured Poster
darrinallen 0
Newbie Poster
markchicobaby 1
Light Poster
pratik_garg
commented:
faster but not what alidabiri want as answer -1
ishii 0
Newbie Poster
ishii 0
Newbie Poster
biswaranjan111 -3
Newbie Poster
debasisdas
commented:
read question properly before replying. -3
biswaranjan111 -3
Newbie Poster
aksclusive 0
Newbie Poster
madhuravula 0
Newbie Poster
QVeen72 104
Posting Shark
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.