naming id columns database tables

i wondering peoples opinions controlling id columns database tables.

if i have list called invoices primary pivotal an spirit buttress i buttress invoiceid i dispute tables it's apparent is.

where i am workind tide have called id columns id.

so following:

select  
    i.id 
,   il.id 
from
    invoices i
    left join invoicelines il
        i.id = il.invoiceid

now, i few problems here:

1. need alias columns select

2. id = invoiceid does fit brain

3. alias tables referred invoiceid apparent list on?

what peoples thoughts topic?

code1