Select specific cols from 2 tables

[greg252]

I have 2 tables
client {
inc int not null auto_increment primary
company varchar (20)
address1 varchar(10)
phone varchar(20)
}

display{
clientid int not null primary // this is the inc from client
website varchar(20)
clicks int
}

I want to select clicks and company where clientid=inc

and I just can't get it.
What's up?

Thanks,
Greg

[ultraslacker]

SELECT clicks, company
FROM client, display
WHERE client.inc = display.clientid

Read your dbms documentation on JOINs.

[greg252]

Got it, thanks.
name the cols sep by comma, FROM tables seperated by comma.
WHERE table.col

Thanks Again.