Joins

• Arjun SreeVastsva

  SSCertifiable

  Points: 7150

  More actions

  July 2, 2019 at 6:04 pm

  #3659460

  Hi,

   

  i need to retrieve the

   

  Table 1

  A B C

  1 2 3

  2 4 6

  3 5 6

   

  Table 2

  B E

  2 4

  2 6

  3 4

  3 8

  Table 3

  E F

  1 9

  1 7

  1 6

   

  I need to retrieve the results of F=1 values.

  can any one help me

• pietlinden

  SSC Guru

  Points: 63560

  More actions

  July 2, 2019 at 6:11 pm

  #3659462

  got CREATE TABLE and INSERT scripts?

  That post is nonsensical without them

• Phil Parkin

  SSC Guru

  Points: 247137

  More actions

  July 2, 2019 at 6:45 pm

  #3659473

  People might be able to help, if you can ask the question properly & post DDL, INSERT statements and desired results. I have no idea what you are asking for as things stand.

  ---