JOIN statement not producing expected output

Okay, now this is my first try on fetching data from two tables, and frankly I'm starting to pull my hair out ;) All I want is to fetch some data from two seperate tables in my database. So far I have tried different approches, and below is what I think should work, but doesn't :( SELECT * FROM table1,table2 This I pasted into phpmyadmin, and it outputted two rows from table2 with ekstra columns at the tail of each row. These ekstra columns was just the same output from table2. Now I have searched the web, but have not found a simple solution for my problem. Any ideas? If you need more info, please let me know :) -Lasse