RE: QUERY HELP - IF THEN ELSE

2001-11-13 Thread Rick Emery
ssage- From: Pawandeep Lamba [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 13, 2001 9:56 AM To: [EMAIL PROTECTED] Subject: QUERY HELP - IF THEN ELSE Hi... I want to output results based on the query from 3 tables ( described here ) TABLE 1 SUBID (SAME AS IN TABLE 2)

QUERY HELP - IF THEN ELSE

2001-11-13 Thread Pawandeep Lamba
Hi... I want to output results based on the query from 3 tables ( described here ) TABLE 1 SUBID (SAME AS IN TABLE 2) ID FILE DATE DISCIPLINE (SAME AS IN TABLE 3) TABLE 2 NAME SUBID (SAME AS IN TABLE 1) TABLE 3 NAME EMAIL