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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by rezbin
-
how to make this query with 3 table
Hello towerbase, i think my question is related with this topic so i am stating again here. my question is, can i use "UNION ALL" and "JOIN" together? here is my query: SELECT e.name, jd.num_jobs job_done, jf.num_jobs job_failed, jd.avg_score score, IFNULL(jd.num_jobs, 0) + IFNULL(jf.num_jobs... -
how to make this query with 3 table
Hello towerbase, Thanks for your advice. sure i will go for this book. and the good news is i solved the problem. i have a question, dont know is it logical or not, is it possible to join 3 table and UNION ALL only a single column from both table like date column in a single query? -
how to make this query with 3 table
dear SimonSellick, Thanks a lot for your help.however its showing error when i tried to execute. will you please check again if we missed something? You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'GROUP BY... -
how to make this query with 3 table
Hi, can anyone show me the procedure to make this happen, i am new on this. emp_id--Name 1-------AA 2-------AB 3-------AC 4-------AD 5-------AE 6-------AF 7-------AZ 2)table job_done emp_id --- date - --job_done --score 1 - - - 22-06-2011 -------1-------50 3 - - - 23-06-2011--------1-------25 5...
