jeudi 31 mars 2016

how to select all value from two table

 tableA                   tableB
IdPrice      price             id         tax          IdPrice
----------------------       ------------------------------------
  4          100               1          20              4
------------------------     ------------------ ------------------
  5          150               2          10              6
------------------------     ------------------ ------------------
  6          270            
------------------------
result =
price   id   tax
----   ---   ----
100      1    20
150      2    10
270    null  null
my Query
SELECT   price,id,tax
FROM  tableB INNER JOIN
tableA ON tableA.IdPrice= tableB.IdPrice
but this result 

price   id   tax
----   ---   ----
100      1    20
150      2    10

Aucun commentaire:

Enregistrer un commentaire