likep and join

Faiz · Post by **Faiz** » Fri Dec 07, 2001 5:25 pm

Hi,
I want to join two tables with likep queries on virtual fields on both the tables, but it does not recoginse the fields when I run the query.
For example, when I run this query,
select a.Title from projects a, comments b
where a.project_id=b.project_id
and a.Title\Description\Body likep $query
and b.comm_text\Body likep $query
it gives, field a.Title\Description\Body not found.

Can I join tables with likep clauses?

Post by **mark** » Fri Dec 07, 2001 5:56 pm

Do Title, Description, and Body all exist in table a and do comm_text and Body both exist in table b?
What's your texis version and release?

Faiz · Post by **Faiz** » Fri Dec 07, 2001 6:20 pm

Oh yes they do. And I have created metamorph inverted index on Title\Description\Body in table a and on comm_text\Body in table b. Infact if I run the queries separately on two tables they give desired results.
Current version is,
Texis Web Script (Vortex) Copyright (c) 1996-2001 Thunderstone - EPI, Inc.
Commercial Version 3.01.987613528 of Apr 18, 2001 (sparc-sun-solaris2.6)
I received upgrades a couple of days back but not yet installed. will do it this weekend.