INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Retrieve transaction report

Retrieve transaction report

(OP)
Hi

I currently do transaction report by cash , criteria is any "transaction by 'cash' " must display in report.
other transaction like Cheque no need display hammer hairpull

table_collection
IC-------- Item------------ Receipt--- Mode_Of_Payment----- Transaction_STATUS ------ COLLECTED_DATE
T123----- Addidas-------- rc01------- Cheque------------------ Cancel----------------- 12-dec-2012
T123----- Addidas-------- rc01------- Cancel Transcation------ Cancel---------------- 12-dec-2012
B567----- Nike------------- rc02------- Cash--------------------- Cancel---------------- 12-dec-2012
B567----- Nike------------- rc02------- Cancel Transcation------ Cancel---------------- 12-dec-2012
C890----- New Balance--- rc03------- Cancel Transcation------ Cancel--------------- 12-dec-2012
C890----- New Balance--- rc03------- Cheque------------------ Cancel--------------- 12-dec-2012
D112----- Reebok---------- rc04------- Cash------------------ Active--------------- 12-dec-2012

Expected output
IC--------- Item----------- Receipt--- Mode_Of_Payment------- Transaction_STATUS------ COLLECTED_DATE
B567------ Nike----------- rc02------- Cash----------------------------- Cancel-------------- 12-dec-2012
B567------ Nike----------- rc02------- Cancel Transcation------------ Cancel------------- 12-dec-2012
D112------ Reebok---------- rc04------- Cash------------------------- Active------------------ 12-dec-2012

thanks

RE: Retrieve transaction report

I guess you want something like:

SELECT *
FROM table_collection
WHERE IC IN (SELECT IC FROM table_collection WHERE Mode_Of_Payment = 'Cash')

i.e. all rows for a transaction where cash has been involved at least once.

RE: Retrieve transaction report

Yeah, thats a part of the beaty of SQL, the same problem can be solved in completely different ways. (Somewhat confusing for beginners?)

Note that my solution is Core SQL-99 compliant!
(http://developer.mimer.com/validator/parser99/, a great time saver when writing "portable" SQL.)

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close