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 dencom 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: *

  • Users: dcjeans
  • Content: Threads
  • Order by date
  1. dcjeans

    Possible to get a total sum of results from a query?

    I have a query for an inventory catalog that looks like this. select RIGHT(C.barcode, 12), C.description, C.size, (select sum(stock_count) from count_update where barcode = RIGHT(C.barcode, 12)) TotalCount, (select stock_count from count_update where barcode = RIGHT(C.barcode,12))-(select...
  2. dcjeans

    Simple query question.

    I am having a hard time creating a simple query. I have two tables. "last_count" which has the columns "barcode" "location", and "count" and "slow" which has columns "barcode" and "description". The basic idea, is that "last_count" contains an inventory count of my entire catalog with seperate...

Part and Inventory Search

Back
Top