----- Original Message ----- From: "John Mayson" <[EMAIL PROTECTED]> To: "MySQL List" <[EMAIL PROTECTED]> Sent: Saturday, December 22, 2001 10:11 AM Subject: Help with join
> I'm still in the learning mode with mySQL. > > I have two tables (frequencies and agencies), both contain a column called "uid". I wish > to join these two tables. When I run this... > > USE radio; > SELECT f.freq1, f.ctcss1, f.callsign, a.agency > FROM frequencies as f > JOIN agencies as a ON f.uid = a.uid; USE radio; SELECT f.freq1, f.ctcss1, f.callsign, a.agency FROM frequencies as f INNER JOIN agencies as a ON f.uid = a.uid; or SELECT f.freq1, f.ctcss1, f.callsign, a.agency FROM frequencies as f,agencies as a WHERE f.uid = a.uid; Kittiphum Worachat www.hatyailab.com --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php