Member Avatar for gunso4050
gunso4050 0 Light Poster

Hi everyone,

I am currently trying to retrieve data from 3 Access related tables that have been imported into VB2008 DataSet designer. I am not sure whether or not I still need to join the tables.

SELECT R.CustomerID, C.FirstName, C.LastName, R.ExpiryRenewalDate, R.StartDate, R.MailboxID, R.RentalID, M.BoxSize, RT.Personal, RT.Business
FROM Receipt AS R, Mailbox AS M, Rental AS RT, Customer AS C
WHERE R.ExpiryRenewalDate < GETDATE()
ORDER BY Receipt.ExpiryRenewalDate DESC;

Thank you in advance.

gunso4050

  • 1 Contributor
  • 0 Replies
  • 61 Views
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.