There are 10 rows in Table A and 0 Rows in table B. If you fire the following query:
10
0
1
Syntax Error