User Profile

Collapse

Profile Sidebar

Collapse
AndrewB
AndrewB
Last Activity: Dec 3 '22, 06:43 AM
Joined: Dec 5 '08
Location: New Zealand
  •  
  • Time
  • Show
  • Source
Clear All
new posts

  • Looking at this with fresh eyes this morning, I think I've nailed it using the examples from both of you. I ended up using Delerna's final example - I didn't realise there would be some entries with identical dates (from a legacy system import, I think), so I changed it to select the MAX id number from the contact table. This seems to be working well, thanks very much. :)
    See more | Go to post

    Leave a comment:


  • Thanks for your help guys, I felt pretty idiotic asking as I work in SQL a fair bit, but was just having a bad afternoon. I'm at home at the moment, but I'll try the ideas you've posted as soon as I get into the office tomorrow. :)
    See more | Go to post

    Leave a comment:


  • Thanks Dickie, I'll give that a shot, but I think I've tried something along those lines before - I should have put in the example that I also need to pull other fields from both tables (such as the person who made the contact, the plan holder's details etc).
    See more | Go to post

    Leave a comment:


  • Selecting the top 1 record from a related table

    Hi guys,

    I tried to search but it seems there's a problem with the search engine at the moment. I'm suffering a bit of a brain freeze and hopefully someone can help me out with this...

    I have two tables I'm focusing on, one contains plans and the second contains contact made with the holders of those plans. I want to pull out all plans, and for each plan - look up the date of the latest contact (including plans where no...
    See more | Go to post
No activity results to display
Show More
Working...