Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Other Forums
 MS Access
 FROM variable???

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-05-09 : 10:39:21
Avach writes "Is there any sql syntax for having a variable and using it or gathering tables and selecting a table based on this variable?

ex.
SELECT "var1"."var2" FROM "var1" WHERE "var2" = whatever . . .

essentially, though the code be short, this is what I'm talking about. I'm not an expert, but I've been doing simple stuff for my brain (boss), grunt work, for a while. I started a project of my own and was wondering if this, or any syntax variant is available to call a FROM table and field from the variant(s)?
I'm under the impression, not.

Home project using Win98, .mdb(2000), mySQL and PWS, HomeSite 4.51 (hs4.51 so that I can code w/ style and no crap). Partially internet and partially intranet & form/report building."
   

- Advertisement -