Database naming conventions

[eluser]garycocs[/eluser]
Hi Lads,

I've been messing with DBs for years now with no solid grounding in the processes. I have managed (for the most part) to develop my rules according to your above.

I'm just wondering about linked tables and the concepts behind it.

I am using the tablename_id as the "foreign key" but that was just the way it came about.

Is there a way to actually link the tables and what are the benefits of this.

For example

My query normally looks like this

select * from city where id = $cityid

select * from pub where city_id = $cityid

etc. etc.

Are there better more efficient ways of doing this??