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 Shaun E 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: ansonee
  • Content: Threads
  • Order by date
  1. ansonee

    Problem With COUNT's

    Hopefully I can explain what I'm trying to do well enough for someone to be able to shed some light on my problem. I have three tables: AIMRETRIEVAL -->ARCHIVERETRIEVAL-->AIMRETRIEVEDITEM. There is a one-to-many relationship between AIMRETRIEVAL and ARCHIVERETRIEVAL. The foreign key on...
  2. ansonee

    Query Question

    I'm new to Tek-Tips so woukld like to first say hi....hi. Onto business ;-) I have an IF statement that to me looks like it should be fine, but for some reason get an error. Here's the statement: IF (SELECT ArchiveType FROM AIM.ArchiveType WHERE ArchiveID = decArchiveID) = 'O' AND (SELECT...

Part and Inventory Search

Back
Top