select b1.MACHINE_NAME, b1.BACKUP_NAME, b1.REMARKS as "Result Day -1", b2.REMARKS as "Result Day -2", b3.REMARKS as "Result Day -3", from LAST_WEEK_BACKUP b1 Left outer Join LAST_WEEK_BACKUP b2 on (b1.MACHINE_NAME = b2.MACHINE_NAME and b1.BACKUP_NAME = b2.BACKUP_NAME) Left outer Join LAST_WEEK_BACKUP b3 on (b1.MACHINE_NAME = b3.MACHINE_NAME and b1.BACKUP_NAME = b3.BACKUP_NAME) where b1.start_time = '2008-06-10' and b2.start_time = '2008-06-09' and b3.start_time = '2008-06-08' order by b1.MACHINE_NAME, b2.BACKUP_NAME;
|SQL Server - Check Constraint or NOT NULL?||11||67|
|SQL Statement to Update Email Domain||2||19|
|Make query more efficient||1||16|
|Could you point how to correctly present an already obtained array from CodeIgniter's model in the View?||4||23|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
22 Experts available now in Live!