V4RB Where condition in join query

[Erne]

Hi Ruslan,

I got this query:

Select m.Recid as [m_Recid], m.Media_Description, m.Euro_Price,  
m.Stock, m.Edition_Date, a.Artist, b.Title, b.Recorded, m.Media,  
m.Items_in_Box, m.Filed_Date, m.Barcode
 From [Media] m
Inner Join [Alb_Med_Linker] bmk On Alb_Med_Linker_Med_link
Inner Join [Albums] b On Alb_Med_Linker_Alb_link
Inner Join [Art_Alb_Linker] abk On Art_Alb_Linker_Alb_link
Inner Join [Artists] a On Art_Alb_Linker_Art_link
  Where False

that returns more than 70000 records...
shouldn't it retun 0 records since Where condition is false?


Cool Runnings,
Erne.

p.s.
just curious, since this query is generated by mistake and I got to  
fix it on 1 table only
I need it for an add cursor