February 22, 2011 at 3:52 pm
Hey, I have a table full of data but what has happened is one record is no longer joined.
as in I have a table which holds record of stock each month of a product. this table also contains supplier codes ect.
What has happened is for some reason this stock has a different stock number but the supplier number, product number ect is unique.
How can I present the data for all months for stock item 15, when half the data was for stock item 14.
Essentially i want to join the data for the months for stock item 14 and 15, based on the fact the both have identical supplier numbers and product codes from that supplier that are also recorded in the table
February 22, 2011 at 4:22 pm
To help those who want to assist you please post the table definitions, provide some sample data, the results need from that sample data. Use the format to provide easily consumable data by clicking on the first link in my signature box and following the sampel code in the article.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply