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!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
SQL SELECT FROM Many To Many
Many thanks, not seen the CASE used in SQL before. Will read up on it. Have a great day. -
SQL SELECT FROM Many To Many
Ok, I really need some help. I have three tables: products, bundles, and bundleItems product(id, name) bundle(id, name) bundleItems(productid, bundleid) OK, What I want to do is return a list of ALL distinct bundles and if they have products associated or not. for example: bundleid...
