|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
Stop making mediocre tutorials.The best tutorials are video! Camtasia Studio makes it easy to create engaging, buzz-building screen videos at any size, in any popular format. Download the free trial!
|
|
#1
August 28th, 2003, 01:23 PM
|
||||
|
||||
|
table AS t functionality in Access
Jet SQL references are sadly lacking....
Code:
SELECT url, page_title FROM
((master_index INNER JOIN term_index ON term_index.t_id = master_index.t_id) LEFT JOIN section_index ON master_index.s_id = section_index.s_id)
WHERE term_index.term = 'foobar' AND section_index.section = 'barfoo';
I'd really like to use abbreviated table names in that.. it's not really as bad as it looks, but I can't figure out how to get Access to accept shortened names for it. Any tips on this subject, links to good references, or prayers for my sanity (I use Access by force, not choice) would be most welcome... ((my apologies to those with lower resolutions...))
|
|
#2
August 28th, 2003, 05:57 PM
|
||||
|
||||
|
Code:
SELECT url
, page_title
FROM (
(
master_index M
INNER
JOIN term_index T
ON M.t_id = T.t_id
)
LEFT outer
JOIN section_index S
ON M.s_id = S.s_id
)
WHERE T.term = 'foobar'
AND S.section = 'barfoo'
rudy
|
|
#3
August 28th, 2003, 05:59 PM
|
||||
|
||||
|
Yeppers, that's how it works on REAL databases and that's what I tried....
But this is Access (97 to be specific) we're talking about, and that just screws its little brain up.
|
|
#4
August 28th, 2003, 07:13 PM
|
||||
|
||||
|
hey, access 97 is what i've got, it's great, send me your mdb, i'll get the query running
my email is on my site http://r937.com/
|
|
#5
August 29th, 2003, 07:36 AM
|
||||
|
||||
|
I'll be damned... it does work like that in Access too... I must have just had a typo that I was missing before..
t'eh - a pox on Access for my mistake!  Thanks r937!
|
|
| Viewing: Dev Shed Forums > Databases > Database Management > table AS t functionality in Access |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
