Posted by othellomy on 12/15/06 04:20

I think you should provide some real examples from your data also, what
you are trying to accomplish by 'bring back additional data'.

Rnt6872 wrote:
> Table A Table B
>
> BOL# B_BOL#
>
> Chargeback#
> Hi All,
> I have been struggling with this for the past few months. I have two
> tables that I'm inner joining on BOL#=B_BOL#. This works fine. Now for
> the problem....When there are chargeback# fields associated with B_BOL#
> they aren't being captured as additional records. None of my tables
> have primary keys because at any given time any field can contain a
> "null" value, so I am unable to assign a foreign key, I think. How can
> I attach the subsequent records to the main record to bring back the
> additonal data? Please help!!!

[Back to original message]