Jump to content
The

what i'am wrong?

Recommended Posts

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;

 

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...

×
×
  • Create New...