Multiply Select Rows in one query

• Kristian123

  Grasshopper

  Points: 16

  More actions

  May 17, 2017 at 10:52 pm

  #150578

  Hello, I'm new here. I do have one question in regards of forming up a select query.

  Imagine I have two tables: Tab_A and Tab_B

  Tab_A has 3 columns and the datas are as follows:

  Col1 == Col2 == Col3
  A==B==C
  D==E==F

  Tab_B has just 1 column

  ColB
  X
  Y

  I want to select something to print Tab_A and add up a new Column which takes data from Tab_B, the result would be as follows

  Col1 == Col2 == Col3 == Col4
  A==B==C==X
  A==B==C==Y
  D==E==F==X
  D==E==F==Y

  I'm not sure what I should use on this. Can anyone help?

  Thank you.

• pietlinden

  SSC Guru

  Points: 63428

  More actions

  May 18, 2017 at 12:24 am

  #1943041

  SELECT TabA.Col1, TablA.Col2, TabA.Col3, TabB.X, TabB.Y
FROM TabA CROSS JOIN TabB