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!

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

Recent content by txematrix

  1. txematrix

    IN clause instead of Sub-select

    Thanks for your help, but it runs dynamically?, if the view is changing every time, the list do the same. what I want to do is the results of a PROMPT but without choosing any value. Thanks in advance for your help
  2. txematrix

    IN clause instead of Sub-select

    Hello, how can I force the use in the SQL statement of the IN CLAUSE instead of a sub-query? I have a table (view) with the values I need, but the performance with sub-query is worst than with IN (values, ...). I hope you understand me, and sorry for my bad english. regards

Part and Inventory Search

Back
Top