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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
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... -
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... -
Updating Multiple fields with Table Joins
I've got a similar issue. Below is my update statement which returns the multiple record error. I've tried some permutations based on this post but can't quite get it. P1: BEGIN UPDATE AIM.AIMRetrievedItem SET ImageFront=NULL, ImageFrontSize=NULL, ImageFrontType=NULL, ImageBack=NULL...
