On Vie, 21 de Enero de 2005, 14:48, Bobby Lawrence dijo: > SELECT <column> FROM (SELECT * FROM <table>) > vs. > SELECT * FROM <table> WHERE <column> IN (SELECT <column> FROM <table> > WHERE <column> = 'aValue') > > If so, the table alias would still not be needed because the columns are > still only coming from one table....
Not in all cases. Is posible to write: SELECT * FROM <table_list> WHERE <column> IN ( SELECT <column> FROM <table_list> WHERE <column> = 'aValue' ) Best Regards, Antonio Gallardo --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
