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; I get this error... ERROR 1064 at line 3: You have an error in your SQL syntax near 'ON f.uid = a.uid' at line 3 What am I doing wrong? John -- John Mayson KC4VJO Linux/Perl/HP-UX/ICT Austin, Texas 78729 30.4560N 97.7851W [EMAIL PROTECTED] http://www.nyx.net/~jmayson --------------------------------------------------------------------- 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
