The Posted April 12, 2020 Share Posted April 12, 2020 Link to comment Share on other sites More sharing options...
Sherin Posted April 14, 2020 Share Posted April 14, 2020 On Sql You have try to cross join query in this way SELECT Suppliers.SupplierID ,Products.ProductName,Suppliers.SupplierName,Suppliers.Address,Suppliers.Phone from Products,Suppliers order by ProductID; Link to comment Share on other sites More sharing options...
dsonesuk Posted April 14, 2020 Share Posted April 14, 2020 WOW! 2233 RECORDS, SEEMS ALL suppliers(29) supplied ALL products (77) 29 x 77 = 2233, well at least you won't have to worry about being short of products with so many Suppliers during corona virus outbreak. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now