أريد صيغة جملة الأستعلام من جدولين

 


[color= #993333; font-weight: bold;]SELECT Table1[color= #66cc66;].Field1[color= #66cc66;], Table1[color= #66cc66;].Field2[color= #66cc66;], Table1[color= #66cc66;].Field3[color= #66cc66;], Table2[color= #66cc66;].Field1[color= #66cc66;], Table2[color= #66cc66;].Field2[color= #66cc66;], Table2[color= #66cc66;].Field3

[color= #993333; font-weight: bold;]FROM Table1 [color= #993333; font-weight: bold;]INNER [color= #993333; font-weight: bold;]JOIN Table2 [color= #993333; font-weight: bold;]ON Table1[color= #66cc66;].Field4 [color= #66cc66;]= Table2[color= #66cc66;].Field4 

[color= #993333; font-weight: bold;]WHERE [color= #66cc66;](Table1[color= #66cc66;].Field5 [color= #66cc66;]= [color= #cc66cc;]0 [color= #993333; font-weight: bold;]OR Table2[color= #66cc66;].Field5 [color= #66cc66;]= [color= #cc66cc;]0[color= #66cc66;]) 

[color= #993333; font-weight: bold;]AND [color= #66cc66;](Table1[color= #66cc66;].Field6 [color= #66cc66;]= [color= #ff0000;]'Any String' [color= #993333; font-weight: bold;]OR Table1[color= #66cc66;].Field7 [color= #66cc66;]= [color= #ff0000;]'Any String'[color= #66cc66;]) 

[color= #993333; font-weight: bold;]AND [color= #66cc66;]([color= #66cc66;](Table1[color= #66cc66;].Field8 [color= #993333; font-weight: bold;]BETWEEN [color= #808080; font-style: italic;]#2009/01/01# AND #2009/12/31#) Or (Table1.Field8 >= #2009/01/01# AN
D Table1.Field8 <= #2009/12/31#)) 

[color= #993333; font-weight: bold;]ORDER [color= #993333; font-weight: bold;]BY Table1[color= #66cc66;].Field1[color= #66cc66;], Table2[color= #66cc66;].Field1[color= #66cc66;], Table1[color= #66cc66;].Field3[color= #66cc66;], Table2[color= #66cc66;].Field3