Using WHERE with INNER JOIN

Question

There is a way to use one WHEREto make a SELECTwith INNER JOIN ?

my case is this:

SELECT CodCli, NomeCli 
FROM tbvendas 
  INNER JOIN tbclientes 
  ON tbvendas.CodCli = tbclientes.AutoCod

I’d like to put a WHERE status = "debitado" where the column status is in the tbvendas

Answer 1

Just add the cloister where in consultation

SELECT CodCli, NomeCli 
FROM tbvendas 
  INNER JOIN tbclientes 
  ON tbvendas.CodCli = tbclientes.AutoCod    
Where Status = 'debitado'

Answer 2

can add the WHERE clause before or after Inner Join

SELECT CodCli, NomeCli 
FROM tbvendas 
    INNER JOIN tbclientes 
    ON tbvendas.CodCli = tbclientes.AutoCod
WHERE status = 'debitado'

to add the WHERE clause in tbclientes, use the AND after the ON comparison

SELECT CodCli, NomeCli 
FROM tbvendas 
    INNER JOIN tbclientes 
    ON tbvendas.CodCli = tbclientes.AutoCod
    AND ...
WHERE status = 'debitado' 

then you can also filter the content of TBCLIENTES