Re: Can I do this in SQL

Sure

select count(A.*) from TableA A, TableB B where B.Y = 'London' and B.Z=A.Q;

Mark

<namnan_at_my-deja.com> wrote in message news:7ruasc$sh0$1_at_nnrp1.deja.com...
> I want to ask the following question in SQL:
>
> I have two tables A and B, where table B contains a column Y that is a
> long text description of another column in B (say column Z).
> So, eg, Y contains 'London' and Z contains 'L'.
> The values of this column Z also exists in Table A (say column Q). So Q
> contains 'L'.
>
> How can I say:
>
> Give me count of all the rows in TableA where TableB.Y = 'London';
>
> Thanks in advance
>
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
Received on Sun Sep 19 1999 - 22:35:50 CDT