SQL Queries

use sql_invoicing;

select * from clients;

select *

from clients as c

join invoices as i

on c.client_id=i.client_id;

select *

from clients as c

join invoices as i

using(client_id)

join payments as p

using(client_id)

join payment_methods as p1

on p.payment_id=p1.payment_method_id;

select c.name,c.state,payment_date,payment_method,p1.name

from clients as c

join invoices as i

using(client_id)

join payments as p

using(client_id)

join payment_methods as p1

on p.payment_id=p1.payment_method_id;

select c.name,c.state,payment_date,payment_method,p1.name

from clients as c

join invoices as i

using(client_id)

join payments as p

using(client_id)

join payment_methods as p1

on p.payment_id=p1.payment_method_id

where state='OR';