cross promotions/sql statements

Enclosed is the details of the project. Please read carefully before bidding. What this project entails is coming up with various SQL Statements to determine what ads can be cross promoted. The way it is determined whether it goes together is by make, model, and year. The relationship between the tables are given in the attachment. Feel free to ask any questions about the relationships between the tables to get a better understanding on the project. What is needed is a procedure. For the procedure would be to come up with SQL Statements to come up with the list of items to cross promote with the auction. There should be 2 parameters to send to the procedure. The first one should be id (ad id). The second one would be how many to return. Currently it is four. However, it needs to be flexible enough so if more are allowed, it would show more. If there are less than the number for the second parameter, then only that number would be shown. The last part is to update the crosspromotions table so I can simply query it for the list after the procedure runs. Must be as efficient as possible. I am open to suggestions on improving the performance of the database by changing the structure if needed. ## Deliverables The source code only for the procedure. There should be two procedures for the deliverables. The first one would be main to show it calling the other procedure. The SQL Statement must work in Access and SQL Server 7.0. This will be used for SQL Server 7.0. Must be coded with Visual Basic. ## Platform Windows 2000