I assume each part can be associated with multiple projects, which is
a many to many relation. In that case you need to create a "join"
table that holds the relation. Table like that are typically just 2
fields, one for the project id and one for the part id. You may want
to add other fields like a timestamp so you know when the part was
added to the project.
Your query on the three tables (projects, projparts, parts) would
look something like this:
SELECT projects.*, parts.* FROM projects
JOIN projparts ON projects.projectid=projparts.projectid
JOIN parts ON projparts.partsid=parts.partsid
WHERE projects.projectid="1222007BB"
You would change those to left joins if you are not sure whether a
project has any parts. If there are no parts, that query would not
return anything.
On Aug 22, 2007, at 5:05 PM, Brian E Boothe wrote:
lets say u have a table called Parts and another called
Projects ,,, how can u associate the Parts Table with the Projects
table so lets say u wanna add a Specific Part to a project maybe
even add three parts from the parts table and associate it with a
specific project ???
so maybe u would have projectid = partsid ?
so your project id lets say would be 1222007BB but u wanna add 7
parts associated with that Projectid
hmm maybe whatever partnumber u add would be associated with the
projectid ???
such as Partnum = projectid ?? with a left join ?
can someone Give me an example of how i would do this ?
thanks alot
i wanna run a query and see the parts associated with each
project ! thats my ultimate goal ,,
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]