This is a web application that is pulling data from an access database. ________________________________
From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of George Oro Sent: Wednesday, October 11, 2006 1:21 AM To: [email protected] Subject: RE: [ms_access] OT: creating a sql statement where and how you want to use the SQL Statement? pls explain more so we can give you exactly what you want, if we know ;D -----Original Message----- From: [email protected] <mailto:ms_access%40yahoogroups.com> [mailto:[email protected] <mailto:ms_access%40yahoogroups.com> ]On Behalf Of Rick Justis Sent: Wednesday, October 11, 2006 8:12 AM To: [EMAIL PROTECTED] <mailto:coldfusion-howto%40yahoogroups.com> ; [email protected] <mailto:ms_access%40yahoogroups.com> ; [EMAIL PROTECTED] <mailto:SQL_beginners%40yahoogroups.com> Subject: [ms_access] OT: creating a sql statement I understand everyone here is really busy but I would appreciate any help on this that I could get. I am having trouble creating a sql statement. I have a table with several fields: field1, field2, field3,...,field10. the value of these fields is chosen via drop down with values from another table with field we'll call "drop". Now in that table each record has a category field. Now I need to create a sql query that will give me the records of the first table where the category of the value of field1-10 is of a certain value. I hope that makes sense and any help is appreciated. table1 ---------- field1 field2 field3 .... field10 table2 --------- drop category Questions?? Thanx... Rick [Non-text portions of this message have been removed] Yahoo! Groups Links [Non-text portions of this message have been removed] Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/ms_access/join (Yahoo! ID required) <*> To change settings via email: mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
