Use the sub-SELECT statement
Engine support for the sub-SELECT statement
Engine support for the sub-SELECT statement
The sub-SELECT approach to working with information works in many, but not all, SQL engines.
You will need to do some investigation to determine whether your specific engine supports it.
Microsoft's SQL Server 2000/2005, Microsoft Access, Oracle 9i/10G/11g, and many other engines do support it.
It seems that the capability becomes more of an issue in PC-based engines, but this is sure to change as more and more of the server-based engines also begin working on your workstation.
You will need to do some investigation to determine whether your specific engine supports it.
Microsoft's SQL Server 2000/2005, Microsoft Access, Oracle 9i/10G/11g, and many other engines do support it.
It seems that the capability becomes more of an issue in PC-based engines, but this is sure to change as more and more of the server-based engines also begin working on your workstation.
