Query

• jsshivalik

  Mr or Mrs. 500

  Points: 525

  More actions

  October 22, 2018 at 11:31 pm

  #375768

  Hi
     I have below data 

  Table1
  		No	DocumentNo	Location	Qty	Price
  		1	AB-1
  		1	Ab-2	Chd	10	100
  		1	Ab-2	Delhi	10	100
  		1	Ab-3	Delhi	10	100
  		1	Ab-3	Bangalore	10	100
  		1	Ab-4	Bangalore	10	100
  		1	Ab-4	Chd	10	100
  		2	CD
  		2	CD	bangalore	20	200
  		2	CD	Delhi	20	200
  Result should be like below
  		1	Ab-1
  			ab-2	Chd	10	100	Delhi
  			ab-3	Delhi	10	100	Bangalore
  			ab-4	Bangalore	10	100	Chandigarh
  		2	Cd
  			Cd	Bangalore	20	200	Delhi
  Table2		No	DocumentNo	EntryNo
  		10	xyz	1

  If No from table1 exists in entryno in table 2 then it should add record . In my case there will be 7 + 1 record in Field No having value 1

  Thanks

• laurie-789651

  SSCertifiable

  Points: 7680

  More actions

  October 24, 2018 at 2:40 am

  #2010893

  Hi

  How are you doing with this?

  There is no obvious reason for the sequencing you show:

  ab-2

  Chd

  10

  100

  Delhi

  Why isn't it

  ab-2

  Delhi

  10

  100

  Chd

  ???