Thread Title: SQL String (How to do a JOIN)

Thread Description (By: Carrzkiss):
This was fun, I am much better at doing Demo's for people then I am at explaining thingsā€¦
This demo is looking at 2 different Tables and doing and AND and OR statement to see where to retreive the data from. Pretty neat way of doing it, as it is always better to do it this way on the Server Side, then doing multiple Select Statements between a bunch of If Statements. You only want to do that is you have a very complexe situation, and this one is not complexe at all. Just plain fun to do!
To view the output, click here: [ => Output <= ]
Download Code (Some codes do not have .zip files with them, sorry!)

This Thread has been viewed: [ 372 ] times

Visit Carrzkiss of Experts Exchange at the following locations.
CFF Coding Source
=>Coding Source
Coding Source is a site designed for sharing of source codes, from different forms of software.
With over 100 Members and growing nearly every day!
Knowledge Base<=
Our Knowledge Base, is packed full of information to help you overcome your coding and trouble shooting issues.

Designed by: EE's very own Carrzkiss.
You know Carrzkiss from his reputation on Experts Exchange, now see his work in action.

EE.CFFCS.COM is Brought to you
by: CFFCS.COM - Carrz-Fox-Fire Coding Source) A ®Carrz-Fox-Fire Promotions©2000-2023 Company