Friday, February 24, 2012

Query to fetch multiple files using Provider=Microsoft.Jet.OLEDB

Query to fetch multiple files using Provider=Microsoft.Jet.OLEDB

 

 

SELECT COLUMN_NAMES
FROM (TABLE_1 C LEFT OUTER JOIN TABLE_2 A ON C.ACCOUNTNUMBER = A.ACCOUNTNUMBER)
LEFT OUTER JOIN TABLE_3] T ON T.ACCOUNTNUMBER = C.ACCOUNTNUMBER

No comments:

Post a Comment

Code Formater

Paste Here Your Source Code
Source Code Formatting Options
1) Convert Tab into Space :
2) Need Line Code Numbering :
3) Remove blank lines :
4) Embeded styles / Stylesheet :
5) Code Block Width :
6) Code Block Height :
7) Alternative Background :
Copy Formatted Source Code
 
Preview Of Formatted Code