The thing that I get annoyed by is when the columns don't match the table names so something like:
create table people(person_id int)
This literally drives me to distraction and I want to throw my computer out of the window :)
create table people(person_id int)
This literally drives me to distraction and I want to throw my computer out of the window :)
create table person(id int)
create table people(id int)
select *
from person
join phone on person.id = phone.person"select id as tablename_id, * from table"
just doesn't feel quite right to me personally
select *
from person p
join phone ph on p.id = ph.person