![]() |
|
|
#1 |
|
Senior Member
Join Date: Jul 2004
Posts: 167
|
ORDER BY in Joins with same columns?
I have a problem.
I have 2 tables with the following columns Table Books: bookid INT(10) productname varchar(50) dateadded INT(10) Table Records: recordid INT(10) productname varchar(50) dateadded INT(10) I'd like to list these in order. Since dateadded is the same column name, can I just do ORDER BY dateadded after it's joined or do I need some other technique? I'd also like to keep the same column name where either books or records gives the data if you know what I mean? So the final query would be: Code:
But that doesn't look right either. Please help!
__________________
** Most misspellings intentional to combat spaham filterz** |
|
|
|
![]() |
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | Search this Thread |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Importing CSV file for numeric columns | wrandall | General | 2 | 10-19-2005 11:42 AM |
| Date GROUP and ORDER | krcoder | SQL syntax | 1 | 02-07-2005 04:29 PM |
| Change row order of tables after it has been created? | Azkaban | Database Design | 1 | 02-07-2005 08:35 AM |
| 3.3 Creating and Using a Database | Administrator | Documentation | 13 | 06-09-2004 04:56 PM |
| 1.6.4 New Features Planned for the Near Future | Administrator | Documentation | 0 | 06-08-2004 02:47 AM |