[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