Re: JOIN statement not producing expected output

If you're looking to do cross-table joins, I'd advise a good book/class on basic SQL or you're going to get in over your head very very quickly. SELECT * FROM table1,table2; This WILL run, but there's no where clause. Therefore it will return all of table1 matched against all of table 2. SELECT * FROM table1,table2 WHERE table1.col1 = table2.col2; will limit your result set to the match of the two tables (and is an implicit INNER JOIN call.) The SQL language is (mostly) database independant. Here's a link to the mySQL website which'll give some basic info on SELECTs. http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#SELECT 'Luck -Szii ----- Original Message ----- From: "admin" <admin@skarnn.dk> To: <php-db@lists.php.net> Sent: Monday, May 20, 2002 5:48 PM Subject: [PHP-DB] 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 > > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php