Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. karibari

    How to use subquery to select records?

    I'm learning Crystal Reports. I want to filter the report to select records that meet 2 criteria. In SQL I would write: SELECT project_num, user_name, trans_type, status_date, status_desc FROM process_log p WHERE status_desc != 'COMPLETED' AND status_date = (SELECT MAX(status_date)...

Part and Inventory Search

Back
Top