Restrictions on Joins

[ameliabob]

I am not sure whether I am formatting this correctly or there is an undocumented restriction.

 

What I am trying to do is to do a search in subfiles to find anything with "Tab" in the contents field and then do an inner join to the filenames table to get its contents.

SELECT subfiles.contents, subfiles.masterId, filenames.rowId, filenames.contents FROM subfiles  where subfiles.contents like'%Tab%' inner join filenames on filenames.rowId=subfiles.masterId

[davej]

I'm really rusty on this stuff. How does that differ from...

SELECT s.contents, s.masterId, f.rowId, f.contents FROM subfiles s, filenames fWHERE f.rowId=s.masterIdAND s.contents LIKE '%Tab%' 

[ameliabob]

Thanks for your suggestion. It worked. It looks like the WHERE always is the last condition.