Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2002
    Posts
    33

    Unanswered: Working with record sets

    Is there a way…
    To create a view using SQL that when I link 2 tables that create multiple record sets, will blank the duplicate fields.
    So if I have in Table 1 record A and in Table 2 record a exist 3 times, I would like not to repeat the information in the record set for the last two records:

    T1 T2
    A A 1
    A A 2
    A A 3
    Will look like:
    A A 1
    A 2
    A 3
    Thanks

  2. #2
    Join Date
    Nov 2002
    Posts
    33

    Re: Working with record sets

    Maybe this looks better:
    Is there a way…
    To create view using SQL that when I link 2 tables that create multiple record sets, will blank the duplicate fields.
    So if I have in Table 1 record A and in Table 2 record a exist 3 times, I would like not to repeat the information in the record set for the last two records:

    T1 T2
    A A 1
    A A 2
    A A 3
    Will look like:
    A A 1
    __________ A 2
    ___________ A 3

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •