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 show us some sample data? Sounds like Table 2 is simply a subset of Table 1?
Hi ToddChitt , sorry I cannot show sample data, but yes the new table is a subset of the original table (almost like a calculated table I believe?) Thanks
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