Dependent Subquery?
This is a discussion on Dependent Subquery? within the MySQL forums, part of the Database Server Software category; --> Hi, why is this subquery dependent? SELECT * FROM SYSlogs.pflog WHERE chargedomain IN (SELECT target FROM SYSconf.aliasdomains WHERE name ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-28-2008, 11:30 AM
| ||||
| ||||
 Dependent Subquery? Hi, why is this subquery dependent? SELECT * FROM SYSlogs.pflog WHERE chargedomain IN (SELECT target FROM SYSconf.aliasdomains WHERE name IN ('xxx','yyy','zzz')) OR chargedomain=0 1 | PRIMARY | pflog | ALL | chargedomain | NULL | NULL | NULL | 5659150 | Using where 2 | DEPENDENT SUBQUERY | aliasdomains | ALL | name | NULL | NULL | NULL | 92 | Using where Regards, André      |
|
02-28-2008, 11:30 AM
| ||||
| ||||
| Re: Dependent Subquery? On 5 Dec, 23:20, "André Hänsel" <an...@webkr.de> wrote: > Hi, > > why is this subquery dependent? > > SELECT * FROM SYSlogs.pflog WHERE chargedomain IN (SELECT target FROM > SYSconf.aliasdomains WHERE name IN ('xxx','yyy','zzz')) OR > chargedomain=0 > > 1 | PRIMARY | pflog | ALL | chargedomain | NULL | NULL | NULL | > 5659150 | Using where > 2 | DEPENDENT SUBQUERY | aliasdomains | ALL | name | NULL | NULL | > NULL | 92 | Using where > > Regards, > André I don't know, but why are you using a subquery when a JOIN is far superior? |
 |
« Stripping the from beginning of field name when it occurs
|
SQL command to show only databases that contain a particular table »
| Thread Tools | |
| Display Modes | |
Linear Mode
|
|
All times are GMT. The time now is 10:42 AM.
