Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2016

    Cool Unanswered: Joining Tables Statement

    I am trying to create a gridview sample of 3 different tables that each is linked to another by a similar column. Here are the 3 tables I have:
    Click image for larger version. 

Name:	1.JPG 
Views:	3 
Size:	15.5 KB 
ID:	16773Click image for larger version. 

Name:	2.JPG 
Views:	4 
Size:	14.2 KB 
ID:	16774Click image for larger version. 

Name:	3.JPG 
Views:	5 
Size:	20.4 KB 
ID:	16775
    The common column in the first 2 is Order Number and in the last 2 is Pallet Number.. I am trying to show these in one gridview with this form.
    Click image for larger version. 

Name:	4.JPG 
Views:	6 
Size:	29.4 KB 
ID:	16776
    the information in the first table should be only listed in the first row and then next to them I am listing all serials of all pallets with information of each pallet..

    I am building this in webform and I could really need someone to put me in the right path of merging these sql tables in this form.

  2. #2
    Join Date
    Dec 2007
    Richmond, VA
    Provided Answers: 5
    that's a presentation item, that needs to be taken care of in your presentation layer, not the database.

Tags for this Thread

Posting Permissions

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