LIMITfunction and join queries

shibby1011ph · #1 (**permalink**) 12-14-04, 06:38

Query 1 : SELECT * FROM TABLE_A, TABLE_B, TABLE_C LIMIT 10 WHERE TABLE_A.ID = TABLE_B.ID AND TABLE_B.ID = TABLE_C.ID
Query 2: SELECT * FROM TableC INNER JOIN (SELECT * FROM TableA INNER JOIN TableB ON ID) RS1 ON ID LIMIT 10

I'm currently using mysql standard v4.1.7. Whenever i run both queries (see above), it generates an error message, which is 'check version....' Could somebody pls tell me what's wrong with my syntax?

r937 · #2 (**permalink**) 12-14-04, 07:47

query 1 is getting an error because LIMIT has to come at the end

Code:

select * 
  from TABLE_A
     , TABLE_B
     , TABLE_C 
 where TABLE_A.ID = TABLE_B.ID 
   and TABLE_B.ID = TABLE_C.ID
limit 10

query 2 is getting an error because the ON clauses are incomplete

Code:

select * 
  from TableA 
inner 
  join TableB 
    on TABLE_A.ID = TABLE_B.ID
inner
  join TableC
    on TABLE_B.ID = TABLE_C.ID
limit 10

shibby1011ph · #3 (**permalink**) 12-14-04, 18:42

yes, you're right. thanks!

Internet Services

Web Development

Digital Marketing

Consumer Tech