Join Problem

[GrommitAPW]

I have a table (tbl_A) and a view (vw_B) -

This syntax works -
SELECT tbl_A.*
FROM tbl_A, vw_B WHERE tbl_A.ID = vw_B.ID

This syntax does not -
SELECT tbl_A.*
FROM tbl_A INNER JOIN vw_B ON tbl_A.ID = vw_B.ID

Any ideas ?

Thanks, Adrian

 

[foxdev]

What error are you getting on the second statement? Robert Bradley

http://www.foxdev.com/

Do you have too much money? Visit

http://www.agrainofhope.org

 

[GrommitAPW]

No error, it just does not return any rows.

Thanks, Adrian