Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
is there a possibility I can make find out about the exact nr., of associations between two tables?
Let me try to explain: If I have two tables and I use an EXISTS() option to load from table B only those records where a value from a specific field in table A exists in a specific field in table B
<=> Then I have all the records from table B where that value from a specific field in some record in table A exists
<=> But I do not know whether every record in table A has one or several records in table B associated to it, there might be some records in table A that do not have a representation in table B. To find out about those, I need to use the EXISTS() option a second time while doing the LOAD the other way round - then I have only those records in table A which do have representations in table B.
Is there any simpler way to get to this point?
Thanks a lot!
Best regards,
DataNibbler
Hi DataNibbler,
maybe an inner join on this key between both tables is an alternatively.
- Marcus
Yep - I guess the result should be the same. I'll try.