subquery VS joining Table
From: Bobby (bobby.saputra_at_epselindo.com)
Date: 08/20/04
- Next message: Aneesh: "Re: Stored procedure question"
- Previous message: Kenneth: "Scripting database"
- Next in thread: Keith Kratochvil: "Re: subquery VS joining Table"
- Reply: Keith Kratochvil: "Re: subquery VS joining Table"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 20 Aug 2004 13:31:27 +0700
Hi....
I see that we can get same data if we use subquery or joining table(ex:
inner/right/left join).
my Question is:
When to use subquery and when to use "join" ? and the plus minus?
Performance? Best Practice?
Thanks....
- Next message: Aneesh: "Re: Stored procedure question"
- Previous message: Kenneth: "Scripting database"
- Next in thread: Keith Kratochvil: "Re: subquery VS joining Table"
- Reply: Keith Kratochvil: "Re: subquery VS joining Table"
- Messages sorted by: [ date ] [ thread ]