|
-
Dec 17th, 2004, 09:27 AM
#1
Thread Starter
Evil Genius
Awkward SELECT statement question
I've got an MSAccess database with 2 tables in, with the following columns:
Table1
UID (number)
Col1 (number)
Col2 (number)
Table2
ID (number)
Desc (text)
Each entry in col1 and col2, equates to table 2's ID field. & what I'd like to return/make in an SQL command is the following
"Grab everything from the Table1 table,
Col1 ordered alphabetically on it's corresponding description column in table2,
Col2 ordered alphabetically on it's corresponding description column in table2"
How can I do this please?????!??!?!?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|