MySQL Inner Join Query...

Lop · #1 (**permalink**) 12-21-2006, 09:40 AM

Why does this not work on Linux MySQL but works fine on Windows MySQL?

Code:

SELECT  * 
FROM quick
INNER  JOIN sites_sit
WHERE quick.id = 506 AND quick.idsit_site_ned = sites_sit.id_sit

Paradine · #2 (**permalink**) 12-23-2006, 05:04 PM

Try removing the inner join and putting just a comma between the two tables. This is short-hand. It may work.

Lop · #3 (**permalink**) 01-10-2007, 09:16 AM

Worked! Thanks!

**WingedPanther** · #4 (**permalink**) 01-11-2007, 04:03 PM

Standard SQL would be:

Code:

SELECT  * 
FROM quick
INNER  JOIN sites_sit
on (quick.idsit_site_ned = sites_sit.id_sit)
WHERE quick.id = 506

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
displaying mysql data into jtextfield.Pls help	iz.ziffa	Java Help	1	05-31-2007 11:58 AM
MYSQL CheatSheet - A must for MySQL Users	reachpradeep	Database & Database Programming	1	03-03-2007 04:05 PM
Toad for MySQL	Lop	Database & Database Programming	0	12-06-2006 12:07 PM
Joins	NeedHelp	Database & Database Programming	2	08-02-2006 06:35 PM
MySQL Resources	dirkfirst	Database & Database Programming	1	05-25-2006 03:31 AM

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)