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
DISCIPLINE (SAME AS IN TABLE 1)
HERE IS MY QUERY, USED IF THEN ELSE to show what i am trying to do. What's
the best/right way to accomplish the results.
----------------------------------------------------------------
select t1.SUBID,t1.ID,t1.FILE,t1.DATE,t1.DISCIPLINE,
t2.NAME,t2.SUBID
from PROPOSALS AS t1, PROFILE AS t2
where t1.ID=0 and t1.SUBID=t2.SUBID
IF(t1.DISCIPLINE='Other') THEN(select
t3.DISCIPLINE,t3.NAME,t3.EMAIL
from ASSOCIATES AS t3)
ELSE(select t3.DISCIPLINE,t3.NAME,t3.EMAIL from ASSOCIATES AS
t3 where
t1.DISCIPLINE=t3.DISCIPLINE)
order by t1.DATE
-----------------------------------------------------------------
My output is going to show
FILE FROM TABLE 1
NAME FROM TABLE 2
NAME FROM TABLE 3
EMAIL FROM TABLE 3
-tia
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
