I am a new mySQL user and am trying to port an MS Access database over to mySQL.
In access you can create queries which serve as "virtual tables". For example I could have two tables, Customer order info and customer order status. I want to present these as a customer order table. I write a query as a go between that calls out both tables. The relevant thing here is that the query is known by the database and I can look at it from the outside as if it were a table (which is usually updatable and if the query is simple structured right can even be insertable) This is important to me because third party software over which I have no control uses my database (via ODBC). I have no control over how it presents data, only which tables it sees. The workaround for having no control over how it presents data is to structure these "virtual tables" the way I want data presented. In configuring this program (Orcad CIS if it matters) I noticed that it can tell the difference between the tables and queries but treated them identically, so I assume that ODBC has some support for this (not surprising since microsoft invented odbc). In reading the docs I get the impression that mySQL does not support this (which I'll readily admit is a kinda fishy concept, though I really need it right now). Symbolically linked tables seemed kind of similar, but not exactly what I wanted (not to mention heavily discouraged). If anybody out there has any ideas on how to do this (or something similar like an easy way to write something that sits between mySQL and ODBC and does the translation) it would be much appreciated. I really want to get rid of access. __________________________________________________ Do You Yahoo!? Check out Yahoo! Shopping and Yahoo! Auctions for all of your unique holiday gifts! Buy at http://shopping.yahoo.com or bid at http://auctions.yahoo.com --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php