Left Quote    Treat your password like your toothbrush. Don't let anybody else use it, and get a new one every six months.
- Clifford Stoll    
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 :

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

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: 3,111 Times | Reply to This | To top
Viewing Page: 1 of 1

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

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