Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Daphni

    MySQL Join 3 table plus calculation

    Thanks for your help r937, The problem was with me and my ignorance of the data. The null values were apearing as there were no other products to compare with for that particular product.
  2. Daphni

    MySQL Join 3 table plus calculation

    Its faulty as not all the product's prices are being calculated. So from a result of 30 rows, showing sellers and all there products, only half of the products' prices are being calculated (with null value's on the other products) to return it's value compared to the other sellers products...
  3. Daphni

    MySQL Join 3 table plus calculation

    Hi All, I have three tables (Sellers, Products and SellerProductsMap that links them thru Seller_ID and Product_ID)I want to display all the sellers from the seller table and show all the products being sold by each seller. However, my boss wants to have a column that shows if a product sold by...

Part and Inventory Search

Back
Top