What's the difference between this... SELECT * FROM Control WHERE LookupType= #foo#
and this? SELECT * FROM #foo# If you're just trying to write less code, it looks to me like multiple tables is the way to go. ;-) Patrick -- Patrick McElhaney 704.560.9117 http://pmcelhaney.weblogs.us ---------------------------------------------------------- You are subscribed to cfcdev. To unsubscribe, send an email to [email protected] with the words 'unsubscribe cfcdev' as the subject of the email. CFCDev is run by CFCZone (www.cfczone.org) and supported by CFXHosting (www.cfxhosting.com). An archive of the CFCDev list is available at www.mail-archive.com/[email protected]
