Sean Breslin wrote:
> Oh...
>
> So the only way to get this to work would be to
> install an actual MySQL database on my own
> computer... Or if my partner gets Sybase
> working...
>
> Thanks a lot for your help. I learned a lot about
> how databases programming actually works the past
> few days.
>
> I do, however, have one last question... When
> creating and testing queries, a few of our queries
> were rejected entirely and I'm curious as to why.
> They all have SELECT nested inside a WHERE, which
> the professor said is correct for SQL. Here's an
> example:
>
> SELECT Id
> FROM Item
> WHERE Type = (
> SELECT Type
> FROM Item
> WHERE (Id =
> SELECT ID
> FROM Purchased
> WHERE (BuyerUN = ?)
> )
> )
>
> (? would be replaced with a variable)
> The above should display all item's IDs that have
> the same Type.
MySQL doesn't support subqueries unless you use MySQL-4.1.x or newer.
-Mark
Mark Matthews
Consulting Member Technical Staff - MySQL Enterprise Tools
Oracle
http://www.mysql.com/products/enterprise/monitor.html