Search
Left Quote    I think there is a world market for maybe five computers.
- Thomas Watson, Chairman of IBM 1943    
Right Quote
 
[login] | [Register]
Forum Index » PHP and mySQL » Viewing Topic and Replies
Post Reply


        Viewing Topic: INNER JOINS Question
  This user is offline  borio
  Subject: "INNER JOINS Question" Posted: @ 10:04 am on Jun 15 2005   
Member #: 45
Rank: User - (3)
Since: 05/30/05
Posts: 3

Hi , I would like to ask a question about INNER JOINS. Is it faster to write all conditions in the 'ON' clause or I should use standart 'WHERE' clause. I will write the next source to give u an example :

'SELECT *
FROM <table1> T1 INNER JOIN <table2> T2
ON T1.<comulmnX > = T2.<columnX& gt;
WHERE T1.[columnY]=&l t;value> '
AND

'SELECT *
FROM <table1> T1 INNER JOIN <table2> T2
ON T1.<comulmnX > = T2.<columnX& gt; AND T1.[columnY]=&l t;value>'.
10x in advance for your cooperation


Edited at 10:12:20 am on 06/15/05


    Viewed: 2,584 Times | Reply to This | To top
Viewing Page: 1 of 1



You must be logged in to post on the forums. Login or Register








"AllSyntax.com" Copyright © 2002-2018; All rights lefted, all lefts righted.
Privacy Policy  |  Internet Rank