I wouldn't have built it like that. Would have had a third table
user products
ProdID | UserID | StepNo |
1 | 2 | 3 |
2 | 3 | 2 |
Then from here you could easily select any combination of product, user and
step. And it would be more flexible because you could add steps without
having to add fields.
If your stuck with that structure
you could do:
select * from product,user
where
(user.userid=Step1Id or
user.userid=Step2Id or
user.userid=Step3Id )
and user.userid=#var#
-----Original Message-----
From: Richard Ramos [mailto:[EMAIL PROTECTED]]
Sent: 23 May 2001 19:54
To: CF-Talk
Subject: Stuck on SQL Query
BlankHello,
I have dug myself into a bit of a rut. I have two tables that are organized
as so.
Production
ProdID | Step1ID | Step2ID | Step3ID
------------------------------------
AUTO | 2 | 3 | 4
| 3 | 2 | 1
User
UserID | UserName
-----------------
1 | Tom
2 | Bob
3 | Mary
How can I set up my query to find information based off of the user? I
understand I can have a many-to-one relation but isn't that based off of
rows? This is just a sample of the Production table. I also will have
dates for each step and need to contain the information based off of a time
period selected. Any insight on how to do a query like this would be great.
Thanks in advance.
Richard Ramos
Network Administrator
Softitler Net, Inc.
www.softitler.com
[EMAIL PROTECTED]
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
