Random Notes on Programming
select id from p4_versions where (versionof, version) = (select id, headver from p4_files where p4path like '%/date.txt');