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: [ 344 ] times