SQL Joins: Which is best?
-
Hi, I would like to know which is the most latest and good way of writing SQL Joins. Is it by using *=, =* etc. eg: select distinct * from employee,department where employee.DepartmentID *=department.DepartmentID ( or)is it ANSI Standard? Eg: SELECT distinct * FROM employee LEFT OUTER JOIN department ON employee.DepartmentID = department.DepartmentID Please help.
rmr
-
Hi, I would like to know which is the most latest and good way of writing SQL Joins. Is it by using *=, =* etc. eg: select distinct * from employee,department where employee.DepartmentID *=department.DepartmentID ( or)is it ANSI Standard? Eg: SELECT distinct * FROM employee LEFT OUTER JOIN department ON employee.DepartmentID = department.DepartmentID Please help.
rmr
shivarishxxxx wrote:
select distinct * from employee,department where employee.DepartmentID *=department.DepartmentID
This type of join is slowly being phased out. The Inner/Outer join is the way to go for you.
the last thing I want to see is some pasty-faced geek with skin so pale that it's almost translucent trying to bump parts with a partner - John Simmons / outlaw programmer
Deja View - the feeling that you've seen this post before. -
shivarishxxxx wrote:
select distinct * from employee,department where employee.DepartmentID *=department.DepartmentID
This type of join is slowly being phased out. The Inner/Outer join is the way to go for you.
the last thing I want to see is some pasty-faced geek with skin so pale that it's almost translucent trying to bump parts with a partner - John Simmons / outlaw programmer
Deja View - the feeling that you've seen this post before.Thanks for your prompt reply.
rmr
-
Thanks for your prompt reply.
rmr
Does anybody know how to get the sql log information? Thanks, Rob http://www.vwsolutions.com