Sign Up ›
  • sravan1.3948243917859526E12
  • NEWBIE
  • 0 Points
  • Member since 2014
  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 2
    Questions
  • 0
    Replies
2 replies

How to Pull the data from two tables by using soql-How to get account names for account who supply part p2.

I have two tables -
accounts                                            products
id    acct name   weight           acct_id    product #           name        status
a1    raju                  25                   a1              p1                  nut              hold
a2    john                 15                   a2              p2                  bolt             open
a3    ajay                 10                    a3              p2                  screw         open
a4    ravi                   05                   a4              p2                  cam            hold
                                                          a2              p3                  amy            hold
1 replies

How to Pull the data from two tables by using soql-How to get account names for account who supply part p2.

I have two tables -
accounts                                            products
id    acct name   weight           acct_id    product #    name        status
a1   raju                 25                   a1              p1                  nut              hold
a2   john                15                   a2              p2                  bolt             open 
a3   ajay                 10                   a3              p2                  screw         open
a4    ravi                  05                  a4              p3                  cam            hold