Selecting latest dates from two tables

Hi all, I have a question about a small medical clinic database. The database has a table with basic demographic info (name, address, birth date, etc.). There are also two subtables. Subtable 1 contains referrals for that patient. Subtable 2 ...

Message posted on the February 21st, 2009 - 2:03 PM ET

Saba to Showcase Latest Enterprise People Systems Collaboration Solutions at Gartner Portal, Contents and Collaboration Summit 2011

IRS to Present Case Study on Quarter Billion Dollar ROI Utilizing Saba Centra Web Conferencing for Virtual Training.

Press published on the March 8th, 2011 - 7:00 AM ET

Samsung GALAXY Note II Combines the Creativity of a Tablet and Productivity of a Smartphone with Truly Unlimited Data and 4G LTE from Sprint

Available this fall; Sign up to receive the latest details on GALAXY Note II at www.sprint.com/galaxynote2.

Press published on the September 19th, 2012 - 7:30 AM ET

Samsung Takes DualView to the Next Level

New ST700, PL170 and PL120 models bring the latest dual screen innovations to all camera users so you can place yourself in the perfect moment.

Press published on the January 5th, 2011 - 4:00 PM ET

Daylight Solutions Launches New MIRcat™ Laser Source with Industry-Leading Mid-Infrared Tuning Range

Daylight Solutions, Inc., a leading manufacturer of molecular detection and imaging solutions in the mid-infrared, today announced the launch of the company’s latest laser system for the Scientific Research market. ...

Press published on the October 1st, 2012 - 4:39 PM ET

BiteHunter Launches 2.0 Mobile App for iPhone to Enhance Interface, Functionality and In-App Purchases

First real-time dining search engine makes its biggest upgrade to date, introduces BiteBuy™.

Press published on the April 5th, 2012 - 8:34 AM ET

Windows Media Center 7 - manage your multimedia content

Windows Media Center, your multimedia content manager (audio, photos, videos, TV, DVD, radio stations) has improved with every new release. The latest engine is provided in the top of the line Windows 7 releases. A warmer welcome menu, compatible ...

Review published on the February 17th, 2010 - 6:10 PM ET

VeriFone Reports Results for the Second Quarter of Fiscal 2012

VeriFone Systems, Inc. (NYSE: PAY), the global leader in secure electronic payment solutions, today announced financial results for the three months ended April 30, 2012 (“Q2 FY12”). Non-GAAP net ...

Press published on the May 24th, 2012 - 2:01 PM ET

Query to return latest dates

Hi Forum, I have a query that returns equipment parts and the ?Arrived on Site? (AOS) dates for these parts. There is also a column for the equipment number (Code) that each part belongs to. The idea is that when all parts of a piece of equipment ...

Message posted on the May 25th, 2012 - 10:28 PM ET

Selecting the latest record for transactions

Hi, I have data for items in transaction format and I need to pick up the most latest information from tht transaction-formatted excel sheet. E.g. S. No. Name Location Status Date 1 Ahmed Karachi Depart 10-08-09 2 Zia ...

Message posted on the September 2nd, 2009 - 12:23 AM ET

Bug#516014: xorg: also seeing this problem in latest from sid

This is a multi-part MIME message sent by reportbug. MIME-Version: 1.0 Package: xorg Version: 1:7.4+3 Severity: normal I upgraded to sid today from an older sid (a month or so out of date, I guess), and I seem to have the same problem. As well ...

Message posted on the August 3rd, 2009 - 10:10 AM ET

Bug#511018: libdrm2: X stopped working after latest drm-snapshot upgrade

Package: libdrm2 Version: 2.4.3+git+20090105+a8c5480-1 Severity: important I put it in libdrm as it is the only part of X11 related software that has been upgraded since last working version. Could be the libdrm1-intel part of the drm-snapshot. ...

Message posted on the January 6th, 2009 - 1:30 PM ET

'dateTime1033' Error when using Date Picker control in browser for

I am using InfoPath 2007 and publishing a browser-enabled form to MOSS2007. I am using multiple controls and data types within the form. When I preview/open the form in InfoPath all controls and data types work correctly, however when the form is ...

Message posted on the August 28th, 2009 - 9:40 AM ET

Selecting from a database where the joins have history

I have a database with two tables, each with a numerical primary key field and a name (text) field, joined by a third containing both the primary key fields from the other two along with an integer containing a unix date to provide the time of the ...

Message posted on the July 24th, 2009 - 5:40 AM ET

selecting latest date