[thelist] SQL: looking for resources, have one question
rudy
r937 at interlog.com
Mon Oct 21 19:37:00 CDT 2002
> There is a way to cheat and have Access build your JOINs for you.
> (Don't let Rudy know!)
on the contrary, scott, this is a great suggestion
i do that all the time myself
you know how a wysiwyg editor's output and handcoded html can differ?
products that build sql through a "user-friendly" interface are like that
except for the access query builder (design view)
i love it
you deserve full credit for mentioning this
i hope you don't mind me adding a couple of words to provide context
<tip type="sql" author="Scott Schrantz">
If you are new to SQL syntax, if you build a Query in Access, it will
construct the SQL statement for you. Just go to Design View to build the
query, then go to View>SQL View, and you can copy and paste from there. If
you draw data from two or more tables, it will build an INNER JOIN.
</tip>
rudy
More information about the thelist
mailing list