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
jeudi 31 mars 2016
how to select all value from two table
Inscription à :
Publier les commentaires (Atom)
Aucun commentaire:
Enregistrer un commentaire