Joining tables in MySQL

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • Chung Leong

    Joining tables in MySQL

    Is there any speed different between

    SELECT a.cow_id, a.name
    FROM cow a INNER JOIN farm b ON a.farm_id = b.farm_id
    WHERE [conditions]

    and

    SELECT a.cow_id, a.name
    FROM cow a, farm b
    WHERE a.farm_id = b.farm_id AND [conditions]

    in MySQL?


Working...