/build/static/layout/Breadcrumb_cap_w.png
02/21/2019 94 views

Boa tarde!


Preciso criar um relatório com informações das duas tabelas.


Obrigado.

0 Comments   [ + ] Show comments

Comments


All Answers

2

Join on ID?


SELECT * 

FROM MACHINE

LEFT OUTER JOIN ASSET ON MACHINE.ID = ASSET.ID

Answered 02/21/2019 by: feeldamped
Purple Belt

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

Share