Re: Automotive Product Database (Structer & PHP)
Posted by: Andrew Gilfrin
Date: March 01, 2006 05:33AM

Ok, what do you mean by multiple applications?

You just need a record per association in the VEH_PRO table.

mysql> select * from veh_pro;
+------------+------------+
| product_id | vehicle_id |
+------------+------------+
| 90034 | 45823 |
| 90034 | 78345 |
| 90034 | 84859 |
| 90034 | 28485 |
| 90034 | 10989 |
+------------+------------+
5 rows in set (0.00 sec)

Andrew Gilfrin
------------------
http://gilfster.blogspot.com
My MySQL related Blog

http://www.mysqldevelopment.com
MySQL Stored Procedure,Trigger, View.... (Just about most things these days) Information

Options: ReplyQuote


Subject
Written By
Posted
Re: Automotive Product Database (Structer & PHP)
March 01, 2006 05:33AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.