var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: LIMITfunction and join queries
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?
query 1 is getting an error because LIMIT has to come at the end
query 2 is getting an error because the ON clauses are incomplete
where TABLE_A.ID = TABLE_B.ID
and TABLE_B.ID = TABLE_C.ID
on TABLE_A.ID = TABLE_B.ID
on TABLE_B.ID = TABLE_C.ID
yes, you're right. thanks!