Hiya all, I have (for illustration purposes) two tables in an ODBC database: Table 'Jobs'=JobID,JobDescription,JobDate Table 'Users'=UserName,JobID,LastViewedDate Basically I want to select all JobID's and JobDescriptions from Jobs where the user has a 'lastvieweddate' within the last 10 days. That bit I can work out - the problem is, is if there isn't an entry in the 'Users' table for a particular JobID. I could include nulls for the UserName for each jobid in the Users table and have an SQL statement in the format: ...AND (Users.UserName='' OR Users.UserName='John Doe')... But that may give me two records - which I don't really want. I could temporarily store the duplicates in a Perl array or hash and remove duplicates that way, but I would prefer a 'pure' SQL solution. Therefore, the question is: * Is there any way of SELECTing Jobs.JobID, Jobs.JobDescription, and Jobs.JobDate with Users.LastViewedDate if the UserName is found in the Users table complete with the corresponding JobID. If there isn't a Users.UserName.Users.JobID=Jobs.JobID entry, still return the Jobs.JobID, Jobs.JobDescription and Jobs.JobDate details. Many thanks, Richy C. [speaking personally] -- Richard Chiswell, Systems Developer. Cradley Print Group. All opinions and comments expressed are NOT necessarily those of the Cradley Print. -- The information contained within this e-mail sent by Cradley Print Ltd. is confidential and is intended for the named recipient only. If you are not the intended recipient please notify us by telephone immediately on 01384 414100 (UK)or +(44)1384 414100 (International) or return it to us by e-mail quoting the name of the sender and the addressee. Please then delete it from your system. Encryption and Viruses ================== Please note that this e-mail and any attachments have not been encrypted. They may therefore be liable to be compromised. Please also note that it is your responsibility to scan this e-mail and any attachments for viruses. Viruses and compromises of security are inherent risks in relation to e-mail. We do not, to the extent permitted by law, accept any liability (whether in contract, negligence or otherwise) for any virus infection and/or external compromise of security and/or confidentiality in relation to transmissions sent by e-mail. Contracts ======== Please note, that contracts may NOT be concluded on behalf of Cradley Print Ltd by e-mail, but contracts on behalf of our clients may be concluded by e-mail.
