Forum Discussion
Relationship Needed?
Hi, I currently have a table in my dataset from SQL which has a column named 'RegistrationLog_id', which is for when different companies submit registration details, which can be more than once (...
Can you MAKE UP something for us to see? Objuscate the crap out of it:
Table 1:
Company Log ID
====== =-===
1 101
1 102
??
Hi ToddChitt, no problem, please see the below.
It is near enough identical, whereby companies are filtered out for their status, and belonging to a region from another database (right join). The latestreg is just a partition by company id for numbering the latest registrations. I hope this helps, thank you