Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Like value from other table
On Sep 21, 5:57 pm, Tony B <anthonybro..._at_googlemail.com> wrote:
> 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
Hi Tony,
The % is a wildcard in Oracle.
http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/sql_elements003.htm#i11223
HTH, Steve Received on Fri Sep 21 2007 - 18:53:53 CDT