how can i select from more than 1 tabe in a querry
in a database tutorial / in the web search for: join
/ how to do joins
Using joins, usually natural joins rather than left or rights because of the performance hit.
select foo.one, bar.two from foo, bar where foo.id=bar.id.
