Ii'm not 100% sure of what it is you are trying to do. Are you looking to
pull all the information in 'tblData' that corresponds to the uid in
tblSomeInfo???? If so, you do this.
SELECT d.*
FROM tblSomeInfo s, tblData d
WHERE s.uid = [whichever uid you are looking for] AND s.uid = d.uid
That will return all the information in tblData that coresponds to the
Information in tblSomeInfo. However, it is an unnecessary process. If you
already know the uid of what you are looking for, just do a select statement
on tblData. Perhaps You can tell me what information it is you are starting
with, and then what info you want from the table structure as a result of
your Query.
-J
-----Original Message-----
From: Chris Porter [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 28, 2000 4:31 PM
To: [EMAIL PROTECTED]
Subject: SQL question
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.
------------------------------------------------------------------------------
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.
