|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
|
|
#1
October 18th, 2003, 09:49 PM
|
|||
|
|||
|
MS-Acess problem
this problem is limited to MS Acess.
i have a table 'x' containing 3 feilds : lhs, rhs and the primary key(id). i want to run a query like: select count(a.user) from a,b where a.user=b.user; here i want 'a' as a value from x.lhs and 'b' as its corresponding value from x.rhs (i.e its x.id should be same). i feel the 'procedure' statement should help. but couldn't find much on it anywhere. thx
|
|
#2
October 19th, 2003, 06:20 AM
|
||||
|
||||
|
do you want to join table X to itself?
Code:
select something
from X as a
inner
join X as b
on a.id = b.id
rudy http://r937.com/
|
|
#3
October 22nd, 2003, 03:28 AM
|
|||
|
|||
|
'a' and 'b' are separate tables in the same database. column 'lhs' and 'rhs' of table 'x' contain the names of othe tables('a' ,'b','c' etc) in the same database.
i hope it is much clear now. i have developed a java code for the required result. i shall try to do the same in VB and then post it. thx anyway.
|
|
| Viewing: Dev Shed Forums > Databases > Database Management > MS-Acess problem |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
