Web Development
Can someone pls help me!!
I have 2 tables in a database for Project/Workflow tracking. One table (Actions table) contains a detailed list of actions with a status column.
The other table contains each project (Project table).
by jaqui
help you what?
you have 2 tablews in a database, so?
what's the problem?
by badair
Well, since you have not stated what you need help with, I will take a leap and assume that you want to use information from both tables, perhaps in another table or report.
If this is the case, then you need to have a common field or column between the two columns, that way you can extract data from both tables using a variety of joining techniques, such as inner or outer joins using sql statements, or sql functionality if these table happen to be in an Access db, the output of the queries can go to another table, or produce a printed report for instance.
So a sample statement could be like: SELECT PROJECT, ACTIONS, STATUS, FROM PROJECT TABLE, ACTION TABLE WHERE STATUS <> CLOSED, AND PROJECT <> 'BLANKS'
If you give some more clues, the quality of the responses posted will be proportional to the information you are able to provide.
Good luck.
by mark88
Maybe it really was urgent....as in his boss might have been right behind him about to fire him....hence the reason why he didn't finish the post or reply since. =)
just a theory....
FD
This discussion is closed to new replies.
Sort by Trending