| Subject: | Re: SQL query problem |
|---|---|
| From: | Azadi <azadi@xxxxxxxxxxxxx> |
| Date: | Wed, 30 Jul 2008 11:13:28 -0400 |
| Newsgroups: | macromedia.coldfusion.database_access |
use LEFT/RIGHT [OUTER] JOIN: SELECT * FROM ptcourses08 c LEFT JOIN coursesession cs ON c.courseid = cs.sessioncourse ORDER BY c.courseTitle and don't use SELECT * - list only columns you actually need returned by your query instead. Azadi Saryev Sabai-dee.com http://www.sabai-dee.com/ |
| <Prev in Thread] | Current Thread | [Next in Thread> |
|---|---|---|
| ||
| Previous by Date: | Re: Select in SQL server, Azadi |
|---|---|
| Next by Date: | Re: SQL query problem, paross1 |
| Previous by Thread: | Re: SQL query problem, Mattastic |
| Next by Thread: | Re: SQL query problem, paross1 |
| Indexes: | [Date] [Thread] [Top] [All Lists] |