Good afternoon, I started working with sql 3 months ago and I'm getting caught up in an application.
I have 3 tables which I have information associated with the "registry"
I would like to get all the information from the first table named configuration even though it is not associated with the other tables and records.
sql = "SELECT *
FROM dividas a
LEFT JOIN registros r on (a.registro = r.registro)
INNER JOIN configuracao b on r.registro = b.registro
WHERE a.empresa='" & LEFT(Combo1.Text, 2) & "'
ORDER BY r.registro"
In this query it brings the information if you have log information in the 3 tables, I want you to also bring the information that only has in "configuration" even if it does not have in "debits" and "records"
If anyone can help me.
Thank you!