[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.


More information about the thelist mailing list