Like value from other table

Hi All

I am new to oracle and am using 10G

In Access I often used the "Like" statement to query Table 1 with a value from table 2 like this:

SELECT tblcompany.IDcompany, tblcompany.Company, tblcompany.Pcode, tblseller.IDSeller, tblseller.SellerNAme FROM tblcompany, tblseller
WHERE (((tblcompany.Pcode) Like [tblseller]![Pcode_1] & " *"));

What is the correct syntax for doing this in Oracle.

TIA Tony Received on Fri Sep 21 2007 - 16:57:52 CDT