hey guys, here's what i'm trying to do.. maybe some of you sql guru's out
there can help. basically, i've got a field in a record that states the
number of records in another table that i want to view & i need a sql query
to gather those rows.
heres the schema
tblSomeInfo tblData
| uid | value | |- uid -|-- value -|
--------|----------| |---3----|---out----|
---1----|-----5----| |---1----|---test---|
---2----|-----3----| |---2----|--- me ---|
---3----|-----7----| |---3----|---out----|
|---4----|--- i ----|
|---5----|--need----|
|---6----|---help---|
the idea is that after this query, depending on which uid in some info,
only the number of records stored in value will be returned. for instance,
assuming it's uid=1, only 5 records would be returned from tblData. or if
uid=2, only 3 records would be returned.
any ideas on how this can be done?
thnx
-chris
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.